Authorizations menu







Authorizations menu option offers copying permissions from other users and changing permissions. Copying permissions from source principal (another user) copies all permissions.

None or Full permissions can be set:
  |
Undefined permissions are defined to none. |
  |
Defined permissions are updated to none. |
  |
Permissions are defined to none. |
  |
Undefined permissions are defined and set to full. |
  |
Defined permissions are updated to full. |
  |
Permissions are defined to full. |
Usergroup members

Databases
Copying permissions from a usergroup to the same usergroup on other databases on the same SQL server instance. Databases where permissions will be copied must be selected. Multiple selection is possible with use of shift or ctrl keyboard button. Only user permissions are copied (permissions that are specificaly set on a user), permissions that user aquires from usergroup are not copied. At the end of copying there's a list of all databases where permissions were not copied because the database is of older version or user does not exist.
