We help IT Professionals succeed at work.

Script Permissions Logins on SL Server DB

Medium Priority
300 Views
Last Modified: 2012-05-07
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.
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.