Re: how can a user who is in a role assign his role to another user?
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 04/27/04
- Next message: Jasper Smith: "Re: Granting EXEC to all my user sprocs in one hit"
- Previous message: Stephen Dybing [MSFT]: "Re: Protecting database from administrators"
- In reply to: samuelzhu: "how can a user who is in a role assign his role to another user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 27 Apr 2004 09:27:13 -0600
The only way I know to set the role owner is when you create
the role, specify the owner of the role in the second
argument for sp_addrole.
In terms of retrieving the owner, I don't remember there
being a direct way. I think it may be that the altuid in
sysusers is the uid for the owner of the role.
-Sue
On Tue, 27 Apr 2004 05:31:04 -0700, samuelzhu
<anonymous@discussions.microsoft.com> wrote:
>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.
- Next message: Jasper Smith: "Re: Granting EXEC to all my user sprocs in one hit"
- Previous message: Stephen Dybing [MSFT]: "Re: Protecting database from administrators"
- In reply to: samuelzhu: "how can a user who is in a role assign his role to another user?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
