Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.DBC_GRANTS
Table FPSADMIN.DBC_GRANTS"
Database Checker table to store grants which changed between this instance and the referenced linked instance.
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: OWNER, TABLE_NAME, GRANTEE, GRANTOR, PRIVILEGE, GRANTABLE
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OWNER |
VARCHAR2(30) |
N |
|
|
TABLE_NAME |
VARCHAR2(30) |
N |
|
|
GRANTEE |
VARCHAR2(30) |
N |
User to whom the privilege needs to be granted (* from FPSADMIN.CFG_ADDL_GRANTS) |
|
GRANTOR |
VARCHAR2(30) |
N |
|
|
PRIVILEGE |
VARCHAR2(40) |
N |
Privilege needed to be granted in caps like SELECT. (* from FPSADMIN.CFG_ADDL_GRANTS) |
|
GRANTABLE |
VARCHAR2(3) |
N |
|
|
COMMENTS |
VARCHAR2(200) |
A comment field allowing a user to document the source or reason of the values populated in the table (* from FPSAPP.GP_C_RSEC_PROCESS_ROUTE) |