Script Permissions Logins on SL Server DB

I have to drop and recreate a DB. Is there a way to script all permissions of users on the DB and apply them soon after i recreate the DB.
suryajandhyalaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mohan_sekarConnect With a Mentor Commented:
I use this tool, which is quite good
http://www.idera.com/Products/Free-Tools/SQL-permissions/
0
 
PIERCGGConnect With a Mentor Commented:
In SQL 2008 you can use the Generate Scripts option in the SSMS.  In the Script Wizard you can set the "SCRIPT OBJECT LEVEL PERMISSIONS" to true.
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
there is an options to script the user logins and object level permissions when you generate the script
0
 
PIERCGGCommented:
This is in addition to my first post....

In case you are not familiar with the Generate Scripts capability....

Open SSMS.  Expand the databases folder.  Right click on a database and in the pop-up menu select TASKS.  In the next pop-up menu, select Generate Scripts.  In the first window that pops up, select the db and say NEXT.  In the second window that pops up you can select everything that you want scripted, including object permissions and logins.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.