CSO_DB_PRIVILEGE_VALUE

This table contains the values assigned to a privilege.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
CSO_DB_PRIVILEGE_VALUE_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
AUDIENCE	NUMBER			The audience for this privilege value. Values are 1 - UserGroups, 2 - Reputation Level.
ACTIVITY_VALUE	NUMBER			The activity value determines if this restriction is turned on for the privilege type. 1 - ON, 0 - OFF
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	Date record was last modified in repository.
PRIVILEGE_ID	VARCHAR2	32	Yes	This is the GUID reference to the dbprivilege object.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
USER_LEVEL	NUMBER			This is the user level assigned to this privilege. Only applies if the audience is of type Reputation Level.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_DB_PRIVILEGE_VALUE	cso_db_privilege	PRIVILEGE_ID
cso_db_priv_val_user_grps	cso_db_privilege_value	PRIVILEGE_VALUE_ID

Indexes

Index	Uniqueness	Columns
CSO_DB_PRIVILEGE_VALUE_U1	Unique	RECORD_ID
CSO_DB_PRIVILEGE_VALUE_N1	Non Unique	PRIVILEGE_ID