<div>
Go into Query Analyzer and issue this command:<br />
<br />
SETUSER 'optionalDomain/userYouWan<wbr />tToSimulat<wbr />e'<br />
<br />
Then any commands you issue will use the permissions of that user.<br />
<br />
To reset back to your sa user, do this:<br />
<br />
SETUSER &nbsp;--[with no params]<br />

</div>


Go into Query Analyzer and issue this command:

SETUSER 'optionalDomain/userYouWantToSimulate'

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]


<div>
<div class="content wysiwyg-content">
This is a followup question to <br />
<br />
<a href="https://www.experts-exchange.com/questions/21088779/db-owner's-permission.html" rel="ugc">https://www.experts-exchange.com/questions/21088779/db-owner's-permission.html</a><br />
<br />
How can SA test user permission without actually logging in as that user
</div>
</div>


This is a followup question to 

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21088779.html

How can SA test user permission without actually logging in as that user

test user permission without acutually logging in as that user

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.