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