I have SysAdmin permissions on our SQL Server 2008 R2 databases.
How would I list the effective permissions, like modify, delete, insert, that someone else has on a particular table in a database?
I tried doing this:
EXECUTE AS USER = 'beta\ldecaprio;
SELECT * FROM fn_my_permissions('Employers', 'OBJECT')
ORDER BY subentity_name, permission_name ;
but I get this message:
Msg 15404, Level 16, State 19, Line 1
Could not obtain information about Windows NT group/user 'MyDomain\ldecaprio, error code 0x5.
I found this on msdn, since the problem with that seems to be that I don't have Impersonate permissions on ldecaprio :
GRANT IMPERSONATE ON LOGIN::WanidaBenshoof to [AdvWorks\YoonM];
But, I don't know if there are any "side effects" that I should be aware of or if this is even something I should/could do.
Please show me exactly how I should list the effective permissions that 'ldecaprio' has on the 'Employers' table in a database, including getting "Impersonate" permissions on ldecaprio's login.