Oracle Permission Generator

Tutorial Part 5 - Adding the Objects

Next, the XYZ Online database objects should be added to Oracle Permission Generator. The XYZ Online database requires the following objects...

Tables and Views

Name Type Description
CUSTOMERS Table Stores details of all the customers of XYZ Online
ITEMS Table The items which XYZ Online sells
ORDERS Table Orders processed by the order management application
APPLICATION_STATS Table Stores statistics generated by the order management application
VW_CUSTOMERS View A de-normalised view of the data in table CUSTOMERS
VW_ITEMS View A de-normalised view of the data in table ITEMS
VW_ORDERS View A de-normalised view of the data in table ORDERS

Stored Procedures

Name Type Description
SP_CUSTOMERS_INS Stored Procedure Handles inserting data into the CUSTOMERS table
SP_CUSTOMERS_UPD Stored Procedure Handles updating data in the CUSTOMERS table
SP_ITEMS_INS Stored Procedure Handles inserting data into the ITEMS table
SP_ITEMS_UPD Stored Procedure Handles updating data in the ITEMS table
SP_ORDERS_INS Stored Procedure Handles inserting data into the ORDERS table
SP_ORDERS_UPD Stored Procedure Handles updating data in the ORDERS table

The objects can be added from the main window. After adding the required objects, the main window should look like this...

Tutorial 5


Continue to Part 6...