how can a user who is in a role assign his role to another user?

From: samuelzhu (anonymous_at_discussions.microsoft.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 05:31:04 -0700

I create a role(eg. HighOperators), and add user 'ABC01' into it. 'ABC01' is not a member of the sysadmin fixed server role or the db_owner fixed database role or the db_securityadmin fixed database role, can he assign his role to another user?
In SQL Server Books Online, it says " Role owners can execute sp_addrolemember to add a member to any SQL Server role they own". but I don't know how to set or get the a role's Owner.

Relevant Pages

  • Re: How to Grant permissions to Database
    ... Is the user ammember of sysadmin server role and db_owner fixed database ... If he/she is not a member of the sysadmin fixed server role but is a member ...
    (microsoft.public.sqlserver.security)
  • Executing fn_trace_getinfo as non system administrator
    ... is not a member of system administrator fixed server role? ... I need to create a user with restricted privileges but still is able to get ...
    (microsoft.public.sqlserver.security)
  • Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont.
    ... he's not a member of either. ... > MSDE database when it is installed locally? ... sure member of sysadmins server role.. ... Andrea Montanari ...
    (microsoft.public.sqlserver.msde)
  • Re: User that can run jobs
    ... Ih the user is not a member of sysadmin server role he/she can execute jobs ...
    (microsoft.public.sqlserver.security)
  • RE: adding users to db fixed roles
    ... >Only members of the sysadmin fixed server role and the ... Role owners can execute sp_addrolemember ... to add a member to ... >database role can add users to any user-defined role. ...
    (microsoft.public.sqlserver.security)