Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.SEC_W_ROLES
Table FPSADMIN.SEC_W_ROLES"
Contains the list of roles for each application. System roles such as "Edit Application Security" are automatically created and should not be deleted..
-
Schema: FPSADMIN
-
Tablespace: FPSDATA
-
Primary key: ROLE_ID
-
Foreign keys: SEC_W_ROLES_APP_FK: APPLICATION_ID REFERENCES FPSAPP.SEC_G_APPLICATIONS (APPLICATION_ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
ROLE_ID |
VARCHAR2(50) |
N |
|
|
APPLICATION_ID |
VARCHAR2(10) |
N |
The id of the application used for joining with other SEC tables. This field is a string field but we normally populate it with a number. (* from FPSAPP.SEC_G_APPLICATIONS) |
|
IS_SYSTEM_ROLE |
CHAR(1) |