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