http://www.sqlservercentral.com/Scripts tagged Security posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Scripts permissions/roles for db user across all databases.http://www.sqlservercentral.com/scripts/Permissions/64309/2008/09/10http://www.sqlservercentral.com/scripts/Permissions/64309/Locate and remove/delete user logins from all databases and even SQL server.http://www.sqlservercentral.com/scripts/Security/63991/2008/08/08http://www.sqlservercentral.com/scripts/Security/63991/Grant permissionshttp://www.sqlservercentral.com/scripts/Security/63922/2008/08/01http://www.sqlservercentral.com/scripts/Security/63922/Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).http://www.sqlservercentral.com/scripts/Administration/63841/2008/10/02http://www.sqlservercentral.com/scripts/Administration/63841/This script will generate a script that would create a Role called "db_SprocReader" and grants "View Definition" permissions to all the stored procedures.http://www.sqlservercentral.com/scripts/Administration/63816/2008/10/08http://www.sqlservercentral.com/scripts/Administration/63816/This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.http://www.sqlservercentral.com/scripts/Security/63774/2008/09/23http://www.sqlservercentral.com/scripts/Security/63774/check public access to extended stored procedureshttp://www.sqlservercentral.com/scripts/T-SQL/63421/2008/08/08http://www.sqlservercentral.com/scripts/T-SQL/63421/Search for GUEST Access Level in all http://www.sqlservercentral.com/scripts/sp_msforeachdb/63420/2008/08/06http://www.sqlservercentral.com/scripts/sp_msforeachdb/63420/These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.http://www.sqlservercentral.com/scripts/Administration/63401/2008/07/30http://www.sqlservercentral.com/scripts/Administration/63401/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63173/2008/06/30http://www.sqlservercentral.com/scripts/Administration/63173/Creates statements for securables creation.http://www.sqlservercentral.com/scripts/Administration/63172/2008/06/26http://www.sqlservercentral.com/scripts/Administration/63172/Check Orphaned logins ie, not associated with any database on the current instance.http://www.sqlservercentral.com/scripts/Administration/63164/2008/07/16http://www.sqlservercentral.com/scripts/Administration/63164/i took the core from a script found in the site for generating permissions and update it. http://www.sqlservercentral.com/scripts/Security/62477/2008/05/06http://www.sqlservercentral.com/scripts/Security/62477/Converts a binary SID to string format.http://www.sqlservercentral.com/scripts/SID/62274/2008/04/02http://www.sqlservercentral.com/scripts/SID/62274/Enhanced sp_help_revloginhttp://www.sqlservercentral.com/scripts/Security/62261/2008/04/09http://www.sqlservercentral.com/scripts/Security/62261/This script will list user permissions for database objects.http://www.sqlservercentral.com/scripts/Security/62064/2008/03/19http://www.sqlservercentral.com/scripts/Security/62064/Make backup several databases with a cursorhttp://www.sqlservercentral.com/scripts/Backup/61888/2008/03/27http://www.sqlservercentral.com/scripts/Backup/61888/Script one or all roles in a database. Includes users, obect permissions and column permissions.http://www.sqlservercentral.com/scripts/SQL+2000/61878/2008/02/20http://www.sqlservercentral.com/scripts/SQL+2000/61878/This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best resultshttp://www.sqlservercentral.com/scripts/Security/61595/2008/01/25http://www.sqlservercentral.com/scripts/Security/61595/Grant permits execution to all user on all sp and functionshttp://www.sqlservercentral.com/scripts/Security/61408/2008/01/04http://www.sqlservercentral.com/scripts/Security/61408/