[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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.
0
suryajandhyala
Asked:
suryajandhyala
  • 2
3 Solutions
 
mohan_sekarCommented:
I use this tool, which is quite good
http://www.idera.com/Products/Free-Tools/SQL-permissions/
0
 
PIERCGGCommented:
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 RetnakaranDatabase 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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now