show grants on table/view for a given user

How to I show what grants have been given to a particular user for a particular table, procedure or view?
LVL 1
jmarkfoleyAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
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
 
chapmandewCommented:
2000 or 2005?
0
 
jmarkfoleyAuthor Commented:
2005
0
 
jmarkfoleyAuthor Commented:
Thanks! That gave me what I needed.
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.