Oracle Permission Generator

Tutorial Part 10 - Supporting a Software Development Lifecycle

Adding New Objects
To support the changes to the XYZ Online data model, Oracle Permission Generator must be modified to add the new objects. After adding the new objects, the main window should look like this...

Tutorial 10


Setting Permissions
The permissions must be correctly set from the main window. After setting the all permissions, the main window should look like this...

Tutorial 10


Setting Add and Remove Properties
The key to using Oracle Permission Generator to support a software development lifecycle, lies in correctly setting the Add and Remove properties for each object. In this case, the Add property should be set for the 4 new objects created as part of the data model change. Similarly the Add property should be unset for all objects which already exist in the data model. The property can be set by clicking the Add checkbox for the relevant object in the main window. After setting the Add properties, the main window should look like this...

Tutorial 10


As the APPLICATION_STATS table is to be dropped in this data model change, its Remove property should be set. The property can be set by clicking the Remove checkbox for the APPLICATION_STATS object in the main window. After setting the remove property, the main window should look like this...

Tutorial 10


Continue to Part 11...