What server permission/ any permission do i need to have to run the
EXECUTE AS USER
For Example) when i execute the below query it is throwing me an error.
The user "dom" has only "processadmin" at server level and few object permissions.
what extra permission is require for 'dom' or the current logged in user/login i.e say "xyz".
Note : "xyz" is also having same "processadmin" server role and few object privileges belong to other users.
EXECUTE AS USER = 'dom;
SELECT * FROM fn_my_permissions('SAMPLE', 'OBJECT')
ORDER BY subentity_name, permission_name ;
Msg 15517, Level 16, State 1, Line 2
Cannot execute as the database principal because the principal "esp_srm" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Thanks in advance