Browse by Tags

• access
• authentication
• copy
• disable
• management
• microsoft
• mixed
• principal
• sa
• script
• self
• server
• sp_help_revlogin
• sql server
• token
• users
• windows

SP_HELP_REVLOGIN for SQL Server 2005
04 September 07 06:54 AM | SQL Master | 2 Comments   

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure Read More...

Filed under: sql server, security, server, login, self, sp_help_revlogin, copy

Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More...

Filed under: sql server, microsoft, security, management, login, windows, mixed, authentication, sa, disable

Script to find out all the groups contain in the login token for every server principal
17 July 07 08:44 AM | SQL Master | 1 Comments   

The following query will get you the information to find out the groups that contain user login token on that server principal: SELECT name , usage , type FROM sys.login_token ORDER BY usage , type , name go To find any Windows principal in the token Read More...

Filed under: sql server, security, script, login, users, principal, token

Script to check user access on master and associated user database
28 May 07 10:16 AM | SQL Master | 0 Comments   

SELECT name , principal_id , type_desc , is_disabled , default_database_name , default_language_name FROM sys.server_principals WHERE name = 'login_name' go SELECT name , database_id , user_access_desc , state_desc , is_in_standby FROM sys.databases WHERE Read More...

Filed under: access, login, security, script