Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag users Rss

   Items 1 to 16 of 16   
 

Script DB Level Permissions v4

Script database and object level permissions for all database users  Read more...
By S. Kusen 2016/03/22 | Source: SQLServerCentral.com | Category: login
Rating: |  Discuss |   Briefcase | 767 reads

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.  Read more...
By Edward Pochinski 2016/02/23 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 827 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2015/09/07 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 4,703 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,551 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,917 reads

Script Login Differences

Compare the logins and users on two instances and generate a TSQL script to make them the same.  Read more...
By Richard Fryar 2015/02/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,551 reads

Script to Set the SQL Server Database Default Schema For All Users

You may come across or even inherit a system where many of the users have different default schemas. Usually, this is easy to remedy - you go into Management Studio, right-click the user, and change the default schema through the UI. Or you write an ALTER USER command manually. But what if you have hundreds of users, across all of your user databases, that should all have the same default schema?  Read more...
By Additional Articles 2013/11/22 | Source: MSSQLTips.com | Category: default schema
Rating: (not yet rated)  Rate this |   Briefcase | 3,459 reads

Script All Logins / Users / and Roles

This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.   Read more...
By Greg Ryan 2015/09/07 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 4,703 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,090 reads

Fix users for SQL 7 thru 2008

This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.  Read more...
By Mike Tutor 2010/02/19 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 2,154 reads

Database Users And Associated Database Roles

This script basically retreives all database users thier database roles for a database.   Read more...
By Larry Sumuri 2010/02/10 | Source: SQLServerCentral.com | Category: users
Rating: |  Discuss |   Briefcase | 3,358 reads

List orphaned users from all databases

The script returns all orphaned database users across a SQL Server.  Read more...
By James Howard 2013/07/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,090 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 | 3,022 reads

Please, Sir, I want some more… orphaned database users.

Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....  Read more...
By jameshoward3 2009/12/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,892 reads

Terminate All User Processes Without Stored Procedure in SQL Server

This script kill all connections on the specified database without stored procedure.  Read more...
By andre.brunaldi 2008/09/10 | Source: SQLServerCentral.com | Category: kill
Rating: |  Discuss |   Briefcase | 254 reads

show users in NT Groups

List users in NT Groups  Read more...
By Mani Singh 2008/07/29 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 1,218 reads
   Items 1 to 16 of 16   
 
Tags
logins (7)    
security (5)    
administration (4)    
orphaned users (2)    
admin (1)    
administrator (1)    
blogs (1)    
connections (1)    
database restore (1)    
database users (1)    
default schema (1)    
kill (1)    
login (1)    
migration (1)    
mirroring (1)    
permission (1)    
permissions (1)    
powershell (1)    
processes (1)    
roles (1)    
script (1)    
sql server (1)    
user (1)    
xp_logininfo (1)