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...
)