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

Content with tags Administration, Security Rss

<< Newer    Items 21 to 40 of 86    Older >>
 

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,649 reads

SQL Agent Roles

By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,248 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,276 reads

Removing TDE

Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.  Read more...
By Steve Perry 2011/11/03 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,772 reads

Database encryption

By Steve Jones 2011/08/29 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,168 reads

SQL Server Central Management Server Security

I have seen several tips on SQL Server Central Management Server and I want to implement the technology for my team. The only thing holding me back is security. Can you explain how security works with Central Management Server? What security access is needed to manage CMS? How about connecting to CMS? How about running a query using CMS? Check out this tip to answer these questions.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,392 reads

Enabling TDE

By Steve Jones 2011/05/30 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,316 reads

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.   Read more...
By Rudy Panigas 2011/03/11 (first published: 2009/11/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,987 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,764 reads

E K M

By Vyas DCS 2010/03/12 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 3,283 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,043 reads

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.   Read more...
By Rudy Panigas 2011/03/11 (first published: 2009/11/03) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,987 reads

The Complete SQL Server 2005 Permissions Report

The script provides complete and comprehensive permission reports, on all SQL Server security hierarchy levels, for all Logins. Reports on particular Logins and databases can be customized.  Read more...
By Richard Lu 2010/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,764 reads

Read_Only Database

By Unknown . 2009/04/10 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 3,936 reads

Extract User-Role Mapping

This short script will list all the users along with their Roles.  Read more...
By Sudhir Chawla 2008/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,788 reads

Password policies checked by CHECK_POLICY

By Diana Dee 2008/11/24 | Category: passwords
Rating: (not yet rated) |  Discuss |   Briefcase | 3,452 reads

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.   Read more...
By Shivaram Challa 2008/10/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,086 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,565 reads

public access to extended SP's

check public access to extended stored procedures  Read more...
By Mani Singh 2008/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 894 reads
<< Newer    Items 21 to 40 of 86    Older >>
 
Tags
sql server 7 (34)    
configuring (9)    
miscellaneous (6)    
t-sql (6)    
programming (5)    
sql server 6.5 (5)    
installation (4)    
sql server 2005 (4)    
strategies (4)    
dts (3)    
encryption (3)    
logins (3)    
role (3)    
stored procedures (3)    
transparent data encryption (tde) (3)    
auditing (2)    
backup / restore (2)    
best and worst practices (2)    
central management server (cms) (2)    
dac (2)    
indexing (2)    
monitoring (2)    
permissions (2)    
replication (2)    
sql agent (2)    
sql-dmo (2)    
triggers (2)    
user (2)    
user defined function (udf) (2)    
worst practices (2)    
ado (1)    
browser service (1)    
databases (1)    
ddl (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
dmv's (1)    
editorial (1)    
english query (1)    
extended stored procedures (1)    
grant (1)    
guest user (1)    
openxml (1)    
passwords (1)    
performance tuning (1)    
public (1)    
roles (1)    
schemas (1)    
script (1)    
scripting (1)    
server roles (1)    
server_principals (1)    
service accounts (1)    
service packs (1)    
sid (1)    
sid mismatch check (1)    
spn (1)    
sql spackle (1)    
sysadmin (1)    
system databases (1)    
updategrams (1)    
users (1)    
visual basic 6 (1)    
xml (1)    
xp_logininfo (1)    
xsl (1)