Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to check permissions for a user in sql server 2005

Posted on 2008-06-10
4
Medium Priority
?
2,270 Views
Last Modified: 2010-05-18
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
Comment
Question by:mshan
  • 2
4 Comments
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21755424
Right click on the user under Security Tab in Management studio and select Properties.
0
 

Author Comment

by:mshan
ID: 21755541
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
 
LVL 8

Accepted Solution

by:
sbagireddi earned 1500 total points
ID: 21755737
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
 

Expert Comment

by:brahma007
ID: 22164782
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question