Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2271
  • 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?
0
mshan
Asked:
mshan
  • 2
1 Solution
 
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
 
sbagireddiCommented:
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
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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