Databases
Databases tab offers copying permissions and/or memberships from user to the same user on other databases, on the same SQL server instance.
The form can be accessed as sub-tab of Security tab, by clicking the individual user on the Users panel in Administration Panel.
The form is made up of certain elements, which we describe below.
|
Name
|
Database name.
|
|
Company
|
Company of database. Sett subject in field This Company in Administration Panel │ Settings │ Company.
|
|
Group
|
The name of group of databases on SQL server.
|
|
Version
|
Database version number.
|
|
Revision
|
Database revision number.
|
|
Permissions
|
If checked ( ), permissions of user will be copied.
|
|
Memberships
|
If checked ( ), memberships of user will be copied.
|
|
|
By clicking, permissions and/or memberships are copied from chosen user to the same user on other databases, on the same SQL server instance.
|
 |
Hint
Databases where permissions or memberships will be copied must be selected. Multiple selection is possible with use of Shift or Ctrl keyboard button.
|
 |
Warning
- Only user permissions are copied (permissions that are specifically set on a user), permissions that user acquires from user group 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.
- If user in target database does not have permissions for changing authorizations, copying permissions is disabled.
|