1. Tables and Views for SCM
  2. DOO_DS_ACCESS_RULES

DOO_DS_ACCESS_RULES

Stores data security conditions for each group of users

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

DOO_DS_ACCESS_RULES_PK

ACCESS_RULE_ID

Columns

Name Datatype Length Precision Not-null Comments
ACCESS_RULE_ID NUMBER 18 Yes Value that uniquely identifies a data security group access rule in order management.
ACCESS_RULE_NAME VARCHAR2 50 Yes Name of a security rule that provides access to data in order management.
DESCRIPTION VARCHAR2 255 Description of a security group that provides access to data in order management.
GROUP_ID NUMBER 18 Yes Value that uniquely identifies a security group that provides access to data in order management.
VIEW_FLAG VARCHAR2 1 Yes Indicates if the access rule grants view order permission for a data security group in order management.
CREATE_FLAG VARCHAR2 1 Yes Indicates if the access rule grants create order permission for a data security group in order management.
REVISE_FLAG VARCHAR2 1 Yes Indicates if the access rule grants revise order permission for a data security group in order management.
EFFECTIVE_FROM DATE Yes Effectivity start date of the access rule for a data security group in order management.
EFFECTIVE_UNTIL DATE Effectivity end date of the access rule for a data security group in order management.
PARTICIPATING_ATTRIBUTES VARCHAR2 255 Yes Summarized list of attributes used in the data security group rule definition.
EXPRESSION_ID NUMBER 18 Yes Value that uniquely identifies the expression defined in the rule builder.
EXPRESSION_JSON CLOB Yes Expression returned by the rule builder in JSON format.
SQL_WHERE_CLAUSE CLOB Yes Where clause that can be used to apply to the access rule
OSCS_DSL_CLAUSE CLOB Yes Filter condition that can be applied to Oracle Search Cloud Service search queries.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ENABLED_FLAG VARCHAR2 1 Yes Status flag to indicate if a security access rule is active or inactive.

Indexes

Index Uniqueness Tablespace Columns Status
DOO_DS_ACCESS_RULES_N1 Non Unique Default GROUP_ID, ENABLED_FLAG, EFFECTIVE_FROM, EFFECTIVE_UNTIL
DOO_DS_ACCESS_RULES_U1 Unique Default ACCESS_RULE_ID
DOO_DS_ACCESS_RULES_U2 Unique Default UPPER("ACCESS_RULE_NAME") Obsolete
DOO_DS_ACCESS_RULES_U3 Unique Default GROUP_ID, UPPER("ACCESS_RULE_NAME")