<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Logins
Items 1 to 18 of 18
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
|
1,730 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
|
1,876 reads
Top 14 KPI
Get the 14 most used Key Performance Indicators
Read more...
By
Monte Kottman
2012/11/09
|
Source:
SQLServerCentral.com
|
Category:
kpi
Rating:
|
Discuss
|
Briefcase
|
2,115 reads
Login Password Policy
This script lists all of the SQL logins with their password policy
Read more...
By
Lee Linares
2012/04/24
|
Source:
SQLServerCentral.com
|
Category:
logins
|
SQL Scripts Manager Compatible
Rating:
|
Discuss
|
Briefcase
|
1,425 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,126 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,200 reads
Audit SQL Logins - Updated
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.
Read more...
By
Derrick H.
2011/05/23
|
Source:
SQLServerCentral.com
|
Category:
auditing
Rating:
|
Discuss
|
Briefcase
|
12,507 reads
Script Logins
Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.
Read more...
By
Gordon Klundt
2011/04/04
|
Source:
SQLServerCentral.com
|
Category:
sp_help_revlogin
Rating:
|
Discuss
|
Briefcase
|
2,450 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,848 reads
Script DB Level Permissions v2.1
Scripts role membership, object-level permissions for all DB users.
Read more...
By
S. Kusen
2011/02/02
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,947 reads
Script DB Level Permissions v2.1
Scripts role membership, object-level permissions for all DB users.
Read more...
By
S. Kusen
2011/02/02
|
Source:
SQLServerCentral.com
|
Category:
security
Rating:
|
Discuss
|
Briefcase
|
2,947 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
|
1,979 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,945 reads
Auditing Failed Logins in SQL Server
An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?
Read more...
By
Additional Articles
2009/05/06
|
Source:
MSSQLTips.com
|
Category:
auditing
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,484 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,469 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
10,799 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,200 reads
Audit SQL Logins - Updated
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script.
Read more...
By
Derrick H.
2011/05/23
|
Source:
SQLServerCentral.com
|
Category:
auditing
Rating:
|
Discuss
|
Briefcase
|
12,507 reads
Items 1 to 18 of 18
Tags
security
(9)
administration
(2)
auditing
(2)
blogs
(2)
permissions
(2)
script
(2)
sql server 7
(2)
users
(2)
batch requests per sec
(1)
buffer cache hit ratio
(1)
connections
(1)
cpu
(1)
database restore
(1)
databases
(1)
ddl triggers
(1)
grant
(1)
idle
(1)
indicators
(1)
kpi
(1)
latch waits per sec
(1)
lock waits per sec
(1)
logouts
(1)
number of deadlocks per sec
(1)
page life expectancy
(1)
page splits
(1)
password policy
(1)
perfmon
(1)
performance tuning
(1)
role
(1)
roles
(1)
scripting
(1)
sp_help_revlogin
(1)
sql server 2005
(1)
total latch wait time
(1)
t-sql
(1)
user
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
