<div>
Options include:<br />
<br />
Third-party tool (i.e. RedGate SQL Compare)<br />
Script (i.e. <a href="http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror" rel="ugc">http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror</a>)
</div>


Options include:

Third-party tool (i.e. RedGate SQL Compare)
Script (i.e. http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror [http://www.sqlsoldier.com/wp/sqlserver/transferring-logins-to-a-database-mirror])

<div>
<div class="content wysiwyg-content">
I have a database table that has a user with 40 or 50 securable references to SPROC, tables etc.<br />
<br />
Is there a way to export those securable references along with their associated granted permissions so they can be applied to the same user in a test environment?<br />
<br />
i.e. &nbsp; Sproc1 &nbsp; &nbsp; stored procedure<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;execute<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table1 &nbsp; &nbsp; table<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; execute, insert<br />
<br />
Thanks
</div>
</div>


I have a database table that has a user with 40 or 50 securable references to SPROC, tables etc.

Is there a way to export those securable references along with their associated granted permissions so they can be applied to the same user in a test environment?

i.e.   Sproc1     stored procedure
         execute
         Table1     table
          execute, insert

Thanks

SQL 2005 Export user securables

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.