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

Content with tags Security, Logins Rss

   Items 1 to 15 of 15   
 

Database User Superfluousness In SQL Server

In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.  Read more...
By Thomas Knight 2014/02/04 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,850 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,371 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,192 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,733 reads

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

Script to clean up “Windows” logins no longer in AD

I was scanning http://dba.stackexchange.com and ran across the following question: http://dba.stackexchange.com/questions/31478/sql-server-script-to-delete-accounts-no-longer-in-active-directory Basically the OP wanted to know how to get rid of...  Read more...
By Kenneth Fisher 2013/03/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,253 reads

Logins vs Users

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....  Read more...
By Kenneth Fisher 2012/12/12 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,228 reads

Remove Logins Script

Generates a script to remove logins from a SQL Instance. Handles cases where logins own schemas.  Read more...
By Steve Griffith 2012/04/05 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,181 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,250 reads

Re-generating SQL Server Logins

SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.   Read more...
By Additional Articles 2011/02/08 | Source: Database Journal | Category: security
Rating:  Rate this |   Briefcase | 4,936 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,371 reads

Script DB Level Permissions v2.1

Scripts role membership, object-level permissions for all DB users.  Read more...
By S. Kusen 2014/01/24 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,371 reads

Resolving User Security Identifier (SID) Discrepancy in Read-Only Databases

Many experienced DBAs understand the issues with matching up users and logins in a restored database. But what do you do when the database is read only? New author Tychang Chen brings us a technique that can help.  Read more...
By Yichang Chen 2009/12/28 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,989 reads

Securing SQL with access control and login monitoring

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.  Read more...
By Additional Articles 2009/02/16 | Source: SearchSQLServer | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,585 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,250 reads
   Items 1 to 15 of 15   
 
Tags
permissions (4)    
role (3)    
roles (3)    
user (3)    
administration (2)    
auditing (2)    
blogs (2)    
comparison (2)    
members (2)    
ownership (2)    
principals (2)    
secure (2)    
sql server 7 (2)    
users (2)    
databases (1)    
ddl triggers (1)    
grant (1)    
script (1)    
scripting (1)    
sql server 2005 (1)    
t-sql (1)