SQL Server 2012 Database Permissions
SQL Server 2012 Database Permissions
(OP)
Hi,
I have created a SQL login in SQL Server 2012 and have specified permissions such as Execute and SELECT directly against certain databases.
How can I generate a script so that it will extract these permissions and I can run the script against a SQL Server in another environment and the user will be created with the same permissions?
Thanks
Tom
I have created a SQL login in SQL Server 2012 and have specified permissions such as Execute and SELECT directly against certain databases.
How can I generate a script so that it will extract these permissions and I can run the script against a SQL Server in another environment and the user will be created with the same permissions?
Thanks
Tom
RE: SQL Server 2012 Database Permissions