Solved

Script Permissions Logins on SL Server DB

Posted on 2009-06-29
4
271 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.
0
Comment
Question by:suryajandhyala
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
mohan_sekar earned 250 total points
ID: 24738197
I use this tool, which is quite good
http://www.idera.com/Products/Free-Tools/SQL-permissions/
0
 
LVL 6

Assisted Solution

by:PIERCGG
PIERCGG earned 125 total points
ID: 24738199
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
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 125 total points
ID: 24738213
there is an options to script the user logins and object level permissions when you generate the script
0
 
LVL 6

Expert Comment

by:PIERCGG
ID: 24738271
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now