Tag: EXECUTE AS
-
Checking what permissions they have in SQL Server
The function sys.fn_my_permissions is very useful for seeing what permissions you have, but it can be just as useful to check someone else. For this all that is needed is to use EXECUTE AS to impersonate them.