|
Home > Archive > MS SQL Server > March 2006 > what members are in each role in a given database?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
what members are in each role in a given database?
|
|
|
| Hello everyone,
For a given database, I want to know what members each database role has:
database role 1: domain\user1, domain\group1, user2
database role 2: user3, user4, domain\user5
.....
I know sp_helprotect can provide MemberOf information. But it's not very
close to what I need. Do I have to tweak the sp_helprotect stored to get
what I want? Is the sysxloings table the only table that has database roles
information?
Any help would be appreciated.
Bing
| |
|
| Found it. sp_helprolemember.
"bing" wrote:
> Hello everyone,
>
> For a given database, I want to know what members each database role has:
>
> database role 1: domain\user1, domain\group1, user2
> database role 2: user3, user4, domain\user5
> ....
>
> I know sp_helprotect can provide MemberOf information. But it's not very
> close to what I need. Do I have to tweak the sp_helprotect stored to get
> what I want? Is the sysxloings table the only table that has database roles
> information?
>
> Any help would be appreciated.
>
> Bing
|
|
|
|
|