Solved

Script Permissions Logins on SL Server DB

Posted on 2009-06-29
4
274 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Removing SCCM 2016 4 51
SQL Lag Function DateDiff 2 26
Datatable / Dates ? 4 30
Delete duplicates from SQL Server table 2 26
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

734 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