Ads 720 x 90

List Object level permissions

 
SELECT c.action, o.name, b.name 
FROM sys.objects o
INNER JOIN sysprotects c
      ON o.object_id = c.id
INNER JOIN sysusers b
      ON c.uid = b.uid
WHERE o.type IN ('U','P','V')
AND b.name = 'LoginName'

Related Posts

There is no other posts in this category.

Total Pageviews

Subscribe Our Newsletter