SQL Server 2012 Database Permissions

[Tom2014]

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]

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.