<div>
Thank You. Alter role works for me.
</div>


<div>
<div class="content wysiwyg-content">
Using sql server 2012 std edition<br />
<br />
I am restoring a database on another server as part of my sql job and then running some data processing jobs on the restored data.<br />
<br />
The problem that I am facing is that the windows user that the data processing job runs under, loses the db_owner role_membership &nbsp;after the restore so the data processing job fails while running data reads.<br />
<br />
How can I set the role membership for this windows user using t-sql after the restore step, and before data processing. I can run this t-sql under a different sql user.<br />
<br />
Thanks.
</div>
</div>


Using sql server 2012 std edition

I am restoring a database on another server as part of my sql job and then running some data processing jobs on the restored data.

The problem that I am facing is that the windows user that the data processing job runs under, loses the db_owner role_membership  after the restore so the data processing job fails while running data reads.

How can I set the role membership for this windows user using t-sql after the restore step, and before data processing. I can run this t-sql under a different sql user.

Thanks.

set the role_membership for this user after the restore

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.