<div>
how's this?<br />
<br />

<pre><code id="code-175856">
Select P.Name, P.type_desc, R.Name as RoleName 
from sys.database_principals P Inner Join 
 sys.database_role_members M on P.Principal_ID = M.member_principal_ID Inner Join
 sys.database_principals R on R.Principal_ID = M.role_principal_ID
</code></pre>
</div>


how's this?




Select P.Name, P.type_desc, R.Name as RoleName 
from sys.database_principals P Inner Join 
 sys.database_role_members M on P.Principal_ID = M.member_principal_ID Inner Join
 sys.database_principals R on R.Principal_ID = M.role_principal_ID


<div>
Thanks....bhess1 and DanielWilson......
</div>


<div>
I found....<br />
exec sp_helprolemember 'db_datareader' &nbsp; &nbsp; is working as well.
</div>


I found....
exec sp_helprolemember 'db_datareader'     is working as well.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I want to find out list of users having db_datareader or any other permission in Database. In my database there are about 200 users some of them have DB_datareader permission and some of them DB_data executor and DB_datawriter....How can I find out list of users having different permission.
</div>
</div>


Hi,
I want to find out list of users having db_datareader or any other permission in Database. In my database there are about 200 users some of them have DB_datareader permission and some of them DB_data executor and DB_datawriter....How can I find out list of users having different permission.

How can I get list of users having DB_datareader or DB_datawriter permission among all users having different permission in SQL 2005 ?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.