RE: Get List of users in a sql server role
From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 06/24/05
- Next message: Gabe Matteson: "SQL Agent Proxy Account"
- Previous message: Jens Süßmeyer: "Re: Authenticating between Webserver and database Server"
- In reply to: Venkat: "Get List of users in a sql server role"
- Next in thread: Hari Prasad: "Re: Get List of users in a sql server role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 24 Jun 2005 07:53:12 -0700
See sp_helprolemember in BOL.
AMB
"Venkat" wrote:
> 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
>
>
>
>
>
>
>
>
- Next message: Gabe Matteson: "SQL Agent Proxy Account"
- Previous message: Jens Süßmeyer: "Re: Authenticating between Webserver and database Server"
- In reply to: Venkat: "Get List of users in a sql server role"
- Next in thread: Hari Prasad: "Re: Get List of users in a sql server role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
