Compare and synchronize permissions of SQL Server databases

Comparison and synchronization settings for database permissions of SQL Server databases

Permissions

Compare and synchronize Permissions.

Restore

Try to restore all kind of database object permissions if they will be lost during the recreation of object or its owner, the altering of grantor or permission chains.

All permissions take a part in the restore, regardless of the selected in the Parameters. If the target database is shown as a database structure file, then the algorithm take into account only those permissions that had been exported to this one.

Add

Add new ones, if they do not exist in the target database.

Alter

Alter existing ones to remove the differences.

Drop

Drop existing ones, if they do not exist in the source database.

Parameters

Parameters of the comparison and synchronization, and the export to the database structure file for Permissions.

You must specify the permissions of which classes and for which categories: grantors and grantees will participate in the comparison and synchronization.

Grantors

Categories of permission grantors.

Mostly it is granted the "dbo" permission and database-level roles. The owner of the object or the database itself or the other grantors that had been given the “WITH GRANT OPTION” permission might grant the permissions.

Owners

All the owners of any objects in the database as principals of the database.

Roles

Database-Level Roles as database principals.

Application Roles

Application roles as the database principals.

Groups

Windows® groups as database principals.

Users

Users as database principals.

Grantees

Categories of permission grantees.

Owners

All the owners of any objects in the database as principals of the database.

Roles

Database-Level Roles as database principals.

Application Roles

Application roles as the database principals.

Groups

Windows® groups as database principals.

Users

Users as database principals.

Classes

Permission classes.

  • Database
  • Roles
  • Application Roles
  • Schemas
  • Database Objects & Columns
  • Assemblies
  • Types
  • XML Schema Collections
  • Message Types
  • Service Contracts
  • Services
  • Remote Service Bindings
  • Routes
  • Full-Text Catalogs
  • Certificates
  • Symmetric Keys
  • Asymmetric Keys