PPM_RESOURCE_SECURITY
This table stores the security for the resources section, this is set up in the request type resources tab.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
RESOURCE_SECURITY_ID |
NULLABLE |
NUMBER |
System-generated identifier |
SECURITY_TYPE |
NULLABLE |
VARCHAR2(200) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
USER_ID |
NULLABLE |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
SECURITY_GROUP_ID |
NULLABLE |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
RESOURCE_SETTING_ID |
NULLABLE |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
TOKEN_TYPE_CODE |
NULLABLE |
VARCHAR2(200) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
TOKEN |
NULLABLE |
VARCHAR2(200) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
PPM_RESOURCE_SECURITY_N1 |
NONUNIQUE |
1 |
USER_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
PPM_RESOURCE_SECURITY_S |
RESOURCE_SECURITY_ID |