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

Content with tags Administration, Permissions Rss

   Items 1 to 5 of 5   
 

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,466 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,520 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,520 reads

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.  Read more...
By Mani Singh 2008/08/01 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 2,502 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh 2008/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,619 reads
   Items 1 to 5 of 5   
 
Tags
t-sql (3)    
grant (2)    
security (2)    
administrator (1)    
columns (1)    
databases (1)    
logins (1)    
object permissions (1)    
role (1)    
script (1)    
scripting (1)    
sql server 7 (1)    
user (1)