Oracle Permission Generator

Tutorial Part 3 - Roles and Users

Relationships between roles, and the users (Oracle schemas) assigned to those roles must be setup in Oracle Permission Generator. These relationships can be added through the 'Edit Master Role to User List' window, which is accessible from the Data menu.

For the XYZ Online database, the following roles and users are required...

User Role Description
XZYON_APP_USER XZYON_APP_ROLE The user associated with the 'APP' role.
XZYON_POWER_USER XZYON_POWER_ROLE The user associated with the 'POWER' role.
SMITH_JOHN XZYON_READ_ROLE A user who will connect directly to the database to run ad-hoc SQL reports.
JONES_SAM XZYON_READ_ROLE A user who will connect directly to the database to run ad-hoc SQL reports.

After adding the relationships, the 'Edit Master Role to User List' window should look like this...

Adding role and user relationships


Continue to Part 4...