Solved

Script Permissions Logins on SL Server DB

Posted on 2009-06-29
4
272 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with SQL Server Polygon 2 32
I Need a T-SQL Query (Union or Intersect, or...?) 6 39
Sql Server group by 10 26
SQL view 2 26
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

786 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