Solved

show grants on table/view for a given user

Posted on 2008-09-29
4
3,706 Views
Last Modified: 2013-11-05
How to I show what grants have been given to a particular user for a particular table, procedure or view?
0
Comment
Question by:jmarkfoley
  • 2
  • 2
4 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22595579
2000 or 2005?
0
 
LVL 1

Author Comment

by:jmarkfoley
ID: 22595659
2005
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22595679
select objectname = object_name(major_id), * from sys.database_permissions d
join sys.database_principals ee on d.grantee_principal_id = ee.principal_id
join sys.database_principals oo on d.grantor_principal_id = oo.principal_id
0
 
LVL 1

Author Comment

by:jmarkfoley
ID: 22595891
Thanks! That gave me what I needed.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now