<< Click to Display Table of Contents >>

Roles

Top Previous Next

The page gives an overview of the roles and system privileges defined in the database and how they have been granted.

The right side of the window shows detail information about the selected role , object privileges and system privileges. For roles, object privileges are shown hierarchically in the the low grid and system privileges belonging to that role are shown in the lower right grid. In the upper right grid, there is a list of users and roles to whom the selected role or system privilege has been granted.

 

Pictured below is an example showing the DBA role:

frmDatabase_Roles

 

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:

SpeedBar_175

Grant object privilege ...

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

SpeedBar_176

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