Get List of users in a sql server role

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Venkat - 24 Jun 2005 14:57 GMT

Can any one tell me the way to get the list of members available
in a particular database role? I need to get the list of roles available in
the database and the list of users available under each role.

Can any one give me T-Sql statements to meet my requirement?

Thanks in advance.

--

Venkat

Reply to this Message

Alejandro Mesa - 24 Jun 2005 15:53 GMT

See sp_helprolemember in BOL.

AMB

> Can any one tell me the way to get the list of members available
> in a particular database role? I need to get the list of roles available in
[quoted text clipped - 7 lines]
>
> Venkat

Reply to this Message

Hari Prasad - 24 Jun 2005 19:40 GMT

Hi,

List of roles available in a database:-

EXEC sp_helprole

List the members in a role

sp_helprolemember

List the members inside a server fixed role:-

sp_helpsrvrolemember <Rolename>

Thanks
Hari
SQL Server MVP

> Can any one tell me the way to get the list of members
> available in a particular database role? I need to get the list of roles
[quoted text clipped - 7 lines]
>
> Venkat

Reply to this Message