Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, scripting, Permissions Rss

   Items 1 to 2 of 2   
 

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,761 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,873 reads
   Items 1 to 2 of 2   
 
Tags
administration (1)    
automation (1)    
backup / restore (1)    
databases (1)    
grant (1)    
job (1)    
logins (1)    
role (1)    
script (1)    
sql server 7 (1)    
t-sql (1)    
user (1)