<< Click to Display Table of Contents >>

Privileges

Top Previous Next

The Privileges grid offers a structured view of:

 

Roles

Users and roles that have had roles granted to them

Assigned object privileges

Assigned system privileges.

 

The display on the Privileges tab presents information about the selected users privileges in four portions of the window:

 

In the upper left corner, the position of the selected role in the hierarchy

Upper right: the users and roles to whom this role has been granted

Lower left: Object privileges of the selected role

Lower right: System privileges of the selected role

 

 

In this example SYSTEM's privileges are displayed. The hierarchy of roles is presented in a tree view.Expanding the root node adds all of its subordinate roles to the view. This process of expansion can be repeated as many times as a role consists of other roles. The end result is a tree view comprising all of the roles that have been granted to the selected user or to the selected role. The DBA role is shown in red type.

roles2

 

The following context operations are available:

 

In the upper left part:

SpeedBar_177

Manage Role Privileges ...

Opens a dialog to grant/remove privileges and roles to the selected user.

 

Default Roles ...

Opens a dialog to alter the default role for the selected user.

 In the lower left part:

66_Grant

Grant object privilege ...

Opens a dialog that lets you grant privileges on the current object to another user or a role.

178_Revoke

Revoke object privilege ...

Revokes the selected privilege.

 

Grid View ...

For more information, see object window

In the lower right part:

SpeedBar_175

Manage System privileges ...

Opens a dialog to grant/remove privileges and roles to the selected user.

 

Grid View ...

For more information, see object window