Permission Wizard

The Permission Wizard allows create any kind of database privileges.

Its functions include:

• Assigning multiple users to a database object
• Assigning multiple roles to a database object
• Assigning multiple database objects to a user
• Assigning multiple roles to a user
• Defining any kind of database object permissions such as SELECT, INSERT, UPDATE, DELETE, etc.
• Defining column-level and fragmentation level permissions.

To assign users or roles to a database object:

1. Select the database object in the Object Explorer.
2. Choose Edit Permissions from the popup menu
3. In the Object Permissions list, select Add from the popup menu or press Add toolbar button. The Permission Wizard will open.
4. Select if you assigning permissions to users or to roles. Press next button.
5. In the list of users or roles, select one or multiple items. Use CTRL+Click or SHIFT+Click to select multiple items. Press Next button.
6. Select required level of permissions and permission details on the following several pages of the wizard. Press Finish button to start creating required permissions in the database.
7. After the execution is completed, review status messages to make sure there were no errors and press Close button.

To assign permissions for database objects to a user or role:

1. Select the user or role under the Object Explorer's Users or Roles folder.
2. Choose Edit Permissions from the popup menu
3. In the Object Permissions list, select Add from the popup menu or press Add toolbar button. The Permission Wizard will open.
4. Select the type of the database object, for which you want to add permissions, for example Tables or Routines. Press next button.
5. In the list of objects, select one or multiple items. Use CTRL+Click or SHIFT+Click to select multiple items. Press Next button.
6. Select required level of permissions and permission details on the following several pages of the wizard. Press Finish button to start creating required permissions in the database.
7. After the execution is completed, review status messages to make sure there were no errors and press Close button.