Get List of users in a sql server role
From: Venkat (tammana_at_inooga.com)
Date: 06/24/05
- Next message: Jens Süßmeyer: "Re: Authenticating between Webserver and database Server"
- Previous message: Alejandro Mesa: "RE: Authenticating between Webserver and database Server"
- Next in thread: Alejandro Mesa: "RE: Get List of users in a sql server role"
- Reply: Alejandro Mesa: "RE: Get List of users in a sql server role"
- Reply: 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 19:27:21 +0530
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: Jens Süßmeyer: "Re: Authenticating between Webserver and database Server"
- Previous message: Alejandro Mesa: "RE: Authenticating between Webserver and database Server"
- Next in thread: Alejandro Mesa: "RE: Get List of users in a sql server role"
- Reply: Alejandro Mesa: "RE: Get List of users in a sql server role"
- Reply: Hari Prasad: "Re: Get List of users in a sql server role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]