inevercheckthis2002 (8/26/2016)[hr
Runnning sp_table_privileges as a sys admin returned results similar to what Gail posted. Which doesn't show me table permissions, just who can grant permissions??? (right?)
No, it shows the granted permissions on that table.
I'm not sure what DMVs to query to get the info on table permissions.
Not the DMVs, sorry. Start with sys.database_permissions and sys.database_principals, and then sys.database_role_members for the roles the user has
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability