SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Security, Logins Rss

   Items 1 to 20 of 26    Older >>
 

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details  Read more...
Rating: |  Discuss |   Briefcase | 218 reads

Deploy Security Changes with Copy-SqlLogin

Moving security changes between server instances can be a cumbersome process, but it doesn't need to be with the PowerShell cmdlet, Copy-SqlLogin.  Read more...
By Steve Jones 2016/11/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,388 reads

Mapping Logins

By Steve Jones 2015/12/24 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,636 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 2015/10/30 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 3,355 reads

Generate Login Script(2008R2 And Older)

Generate Script from Logins of Sql Server to recreate in another instance  Read more...
By Bahram Shayan 2015/08/25 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,690 reads

Login options

By Steve Jones 2015/02/05 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,893 reads

Drop Me? No, I Don't Think So

By Andy Warren 2014/05/14 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 2,199 reads

Can't See The Forest For the Logins

By Andy Warren 2014/03/28 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 1,853 reads

The Unusable User

By Andy Warren 2014/03/26 | Category: logins
Rating: (not yet rated) |  Discuss |   Briefcase | 2,060 reads

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

Script DB Level Permissions v3

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 | 8,473 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,892 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 2015/10/30 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 3,355 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 | 13,926 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 | 3,878 reads

Alter User

By Ole Kristian Velstadbråten Bangås 2013/02/18 | Category: user
Rating: (not yet rated) |  Discuss |   Briefcase | 2,188 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 | 3,414 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,236 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,294 reads

Audit All Permissions

This script will return all permissions on the server.  Read more...
By Jim Sebastiano 2011/11/16 | Source: SQLServerCentral.com | Category: permission
Rating: |  Discuss |   Briefcase | 3,702 reads
   Items 1 to 20 of 26    Older >>
 
Tags
user (7)    
permissions (5)    
administration (4)    
auditing (4)    
role (4)    
roles (3)    
blogs (2)    
comparison (2)    
members (2)    
ownership (2)    
principals (2)    
secure (2)    
sql server 7 (2)    
t-sql (2)    
users (2)    
databases (1)    
dbatools.io (1)    
ddl triggers (1)    
grant (1)    
permission (1)    
powershell (1)    
script (1)    
scripting (1)    
sql server 2005 (1)