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

Content with tag users Rss

   Items 1 to 12 of 12   
 

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,884 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 2013/11/26 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 1,540 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,272 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 2013/11/12 | Source: SQLServerCentral.com | Category: logins
Rating: |  Discuss |   Briefcase | 2,883 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 | 3,911 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,105 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,259 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 | 3,911 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,997 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,743 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 | 249 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,193 reads
   Items 1 to 12 of 12   
 
Tags
logins (5)    
security (4)    
administration (2)    
administrator (1)    
blogs (1)    
connections (1)    
database restore (1)    
database users (1)    
default schema (1)    
kill (1)    
login information (1)    
migration (1)    
mirroring (1)    
orphaned (1)    
powershell (1)    
processes (1)    
roles (1)    
sql server (1)    
xp_logininfo (1)