<div>
Right click on the user under Security Tab in Management studio and select Properties.
</div>


<div>
It gives me the role of the user account.ca you tell me How to find what are privileges the user has on the database like permission for insertion,deletion,updatio<wbr />n?
</div>


<div>
in sql server 2005 we have one function to know permission in sql<br />
select fn_my_permissions(null,'da<wbr />tabase')<br />
u can give different attributes like tablename table<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I am trying to find the permissions for a user account in sql server 2005.How to find what are the permissions the particular user account has on a database in sql server 2005?
</div>
</div>


I am trying to find the permissions for a user account in sql server 2005.How to find what are the permissions the particular user account has on a database in sql server 2005?

Right click on the user under Security Tab in Management studio and select Properties.

It gives me the role of the user account.ca you tell me How to find what are privileges the user has on the database like permission for insertion,deletion,updation?

in sql server 2005 we have one function to know permission in sql
select fn_my_permissions(null,&amp;#39;database&amp;#39;)
u can give different attributes like tablename table



How to check permissions for a user in sql server 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.