Database Access Levels
Your ability to query and interact with AIF database objects depends on the environment you are working with (Production or Non-Production). The following grants and privileges are given to end users in APEX specifically for tables and views in the RI and AIF database users.
| Database Grant | Non-Prod | Prod |
|---|---|---|
|
Insert (Staging Tables) |
Yes |
Yes |
|
Insert (Internal Tables) |
Yes |
No |
|
Update (Staging Tables) |
Yes |
Yes |
|
Update (Internal Tables) |
Yes |
No |
|
Delete (Staging Tables) |
Yes |
Yes |
|
Delete (Internal Tables) |
Yes |
No |
|
Truncate |
No |
No |
|
Create Object |
No |
No |
|
Alter Object |
No |
No |
|
Drop Object |
No |
No |
A staging table is generally any table that receives data from an outside source, which can include flat files, direct
integration between two Oracle solutions, or web services. For example, W_PRODUCT_DS is the staging table
in the RADM01 schema that receives product information. Internal tables include the target tables where
staged data will be moved to for the applications to read from during normal operations, temporary (TMP)
tables, and configuration tables. There are a few exceptions made for application objects that must not be altered, but all
tables that contain data you should need to interact with will be accessible in non-prod environments. W_PRODUCT_D is an example of a target table for the W_PRODUCT_DS staging table.