SQL Server 2012 Database Permissions

Tom2014 · Sep 8, 2014

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

yelworcm · Sep 19, 2014

You should be able to do this with the GUI. Right click on the database in question, and go to tasks->generate scripts... Don't pick "Script Database". Go through the wizard, and pick out the objects/options you want. Have a look at the script, just to be sure, though. There are options for dropping objects in that wizard.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Server 2012 Database Permissions

Tom2014

IS-IT--Management

yelworcm

MIS

Similar threads

Part and Inventory Search

Sponsor