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.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

mohan_sekarConnect With a Mentor Commented:
I use this tool, which is quite good
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.
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
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.
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.