Compare and synchronize permissions of SQL Server databases

Permissions

Compare and synchronize Permissions.

Parameters of comparison and synchronization of database permissions
Restore

Restore the permissions of the database objects, if they will be lost during the rebuild of the object. All permissions will be restored, regardless of the selected in the Parameters. If the target database is shown as a database structure file, then only those permissions that had been exported to this one would be restored.

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 template 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