• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2275
  • Last Modified:

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?
  • 2
1 Solution
Right click on the user under Security Tab in Management studio and select Properties.
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?
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.

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

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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now