Object Type

Displays the Object Type of the Server Explorer node (can be object node, collection node, or connection node) that launched the dialog, with these exceptions: If the Server Explorer node is Schema, User, Role, Users, Roles, Schemas or Connection Node, then Object Type initially lists System Privileges.

Possible values are: Table, View, Procedure, Function, Package, Sequence, Synonym, User-Defined Type, User, Role, Queue, Queue Table, and System Privilege.

Schema

Lists available schemas.

Schema is disabled if Object Type is User or Role.

Please select one of the following

Choose one of the following:

• Grant/Revoke privileges to a user/role on one or more database objects.

• Grant/Revoke privileges to one ore more user(s)/role(s) on a database object.

This control is disabled if Object Type is System Privilege or Role.

Object Name

Select from the list of objects of the specified type owned by the selected schema.

This control varies depending on the selected option in the previous control as follows:

• To select a single database object, select from the drop-down list that appears.

• To select multiple database objects, a select list appears. Press the control key or shift key and select individual database objects.

Object Name appears for all Object Types except Role, User, Schema, Roles, Users, Schemas, or Connection Node.

User/Role

Select either User or Role to indicate the target type of the privilege grant. Defaults to User for all nodes except Role or Roles.

Then, select available users or roles from the list.

The list varies depending on the selected option in the previous controls:

• To select a single user or role, select from the drop-down list that appears.

• To select multiple users or roles, a select list appears. Press the control key or shift key to make multiple selections.

This control is enabled for all object types except for System Privileges.

Privileges

Lists privileges that can or have already been granted to target users or roles. These privileges can be granted with the With Grant option, allowing a user or role to grant it to other users or roles, or With Admin Option for System Privileges. The With Grant or With Admin option column is not included if it does not apply.

The check boxes have three states:

• Checked: All target users or roles have been granted this privilege.

• Unchecked: No target users or roles have been granted this privilege.

• Shaded: Some target users or roles have been granted this privilege, but not all of them.

When appropriate, check boxes have a red border indicating that the user changed the data.

Preview SQL

Displays the SQL that the database executes to grant or revoke privileges.

OK

Saves.

Cancel

Cancels.

Apply

Applies any changes to the database. Any queries that are executed appear in the output pane.

Help

Brings up online help.