5.4 Mapping Users To Access Control Metadata

An Administrator can map each user to Access Control Metadata and Security attributes which will control the user's access permissions. In order to provide this mapping to each user an entry is needed to be made in KDD_REVIEW_OWNER table of the Mantas schema using the following query

Table 5-6 KDD_REVIEW_OWNER table Attributes

Column Name	Description
OWNER_SEQ_ID	Unique identifier of the User.
ACTV_FL	Indicator of whether this user is currently active.
OWNER_DSPLY_NM	The user display name
OWNER_ID	Logon name of this user
OWNER_TYPE_CD	Type of user
CURR_VALID_LOGON_TS	Date and time that this user logged on for the most recent session.
EMAIL_ADDR_TX	Email address of the user
LAST_FAILED_LOGON_TS	Date and time of the last unsuccessful login attempt for this user
OWN_ALERT_FL	Indicator of whether this owner can own an alert (not required for Currency Transaction Reporting)
OWN_CASE_FL	Indicator of whether this owner can own a case (not required for Currency Transaction Reporting)
PREV_VALID_LOGON_TS	Date and time that this user logged on prior to the current session.
RPTG_GROUP_CD	Name of the organization to which this user belongs/reports. (not required for Currency Transaction Reporting)
BUS_DMN_ST	Set of business domains to which this user has access.

INSERTINTO KDD_REVIEW_OWNER (OWNER_SEQ_ID, OWNER_ID,OWNER_TYPE_CD, RPTG_GROUP_CD, ACTV_FL, BUS_DMN_ST,EMAIL_ADDR_TX, OWNER_DSPLY_NM, OWN_ALERT_FL, LAST_FAILED_LOGON_TS, CURR_VALID_LOGON_TS,
          PREV_VALID_LOGON_TS, OWN_CASE_FL)SELECTF_GET_NEXT_VAL('OWNER_SEQ_ID_SEQ'),
            A.V_USR_ID,'USER', NULL,CASEWHEN A.F_USR_DELETE = 'Y' THEN 'N'WHENTO_DATE(SUBSTR(A.D_USR_EXPIRY_DTE, 0, 10),'MM/DD/YYYY')< SYSDATE THEN  YYYY')> SYSDATE THEN'N'WHENTO_DATE(SUBSTR(A.D_USR_EXPIRY_DTE, 0, 10),'MM/DD/ 'Y' ELSE
    A.F_USR_ENABLED
        ENDACTV_FL,'xyz', A.V_EMAIL, A.V_USR_NAME, 'N',NULL, NULL, NULL, 'N'FROM CSSMS_USR_PROFILE A WHEREA.V_USR_ID = 'USER1'COMMIT;