SQLServerCentral.com Content tagged Security, Role

List all Usernames, Roles for all the databases.

Mon, 31 Dec 2012 07:00:00 UT

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).

Audit All Permissions

Wed, 16 Nov 2011 07:00:00 UT

This script will return all permissions on the server.

Understanding SQL Server fixed database roles

Fri, 18 Dec 2009 07:00:00 UT

I know there are fixed database roles that come with SQL Server. How do I best use them within my installations? What should I watch out for? In this tip we will cover each of the database roles and recommendations on when to and when not to use them.

Database Roles

Mon, 23 Feb 2009 07:00:00 UT

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

Wed, 08 Oct 2008 06:00:00 UT

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.

List all Usernames, Roles for all the databases.

Mon, 31 Dec 2012 07:00:00 UT

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).

Permission scripting over all databases

Wed, 10 Sep 2008 07:28:09 UT

Scripts permissions/roles for db user across all databases.