Data Dictionary
>
FPSADMIN Views
> FPSADMIN.WIP_WAFER_HIST_LOOP
View FPSADMIN.BLD_PRIVS_AND_SYNONYMS
This view compares the desired privileges for FPS schemas with the privileges which are currently granted and then builds grant and revoke queries to get us to the ideal state. This view is used by ADM_SET_PRIVILEGES to do this automatically when FPSADMIN has the "grant any object privilege" system privilege. Otherwise the privileges will have to be granted/revoked by each schema. These queries can be run blindly without review as the logic is all built in this view. *** CRITICAL: This view must not refer to any objects in FPS schemas besides FPSADMIN without an *** explicit prefix. If it does, it will introduce a circular dependency that will *** break the DWH_build process.
|
Column |
Comment |
|---|---|
|
GRANTOR |
|
|
OWNER |
|
|
OBJECT_NAME |
This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* inherited from FPSADMIN.CFG_DISABLED) |
|
OBJECT_TYPE |
|
|
GRANTEE |
User to whom the privilege needs to be granted (* inherited from FPSADMIN.CFG_ADDL_GRANTS) |
|
IS_FPSADMIN_ALLOWED |
|
|
SQL_QUERY |
|
|
PROBLEM |
|
|
ADDL_INSERT_QUERY |