How to check permissions for a user in sql server 2005

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?
mshanAsked:
Who is Participating?
 
sbagireddiConnect With a Mentor Commented:
When you click the tab for User mapping  and highlight individual dbs you will see the Database role membership
for each database.

You will see the roles like : db_datareader,db_owner.

To better understand the roles please look up Books Online.

0
 
sbagireddiCommented:
Right click on the user under Security Tab in Management studio and select Properties.
0
 
mshanAuthor Commented:
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?
0
 
brahma007Commented:
in sql server 2005 we have one function to know permission in sql
select fn_my_permissions(null,'database')
u can give different attributes like tablename table

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.