Member_2_1316035
asked on
test user permission without acutually logging in as that user
This is a followup question to
https://www.experts-exchange.com/questions/21088779/db-owner's-permission.html
How can SA test user permission without actually logging in as that user
https://www.experts-exchange.com/questions/21088779/db-owner's-permission.html
How can SA test user permission without actually logging in as that user
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SETUSER 'optionalDomain/userYouWan
Then any commands you issue will use the permissions of that user.
To reset back to your sa user, do this:
SETUSER --[with no params]