This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Page tree
Skip to end of metadata
Go to start of metadata

This document explains ranger 0.4.0 database schema information.It contains list of Tables and its column details for databases supported.

MYSQL

  1. x_portal_user
    DescriptionThis table contains user profile and credentials of Ranger Admin users. it also contains user synced from external sources but credential are not stored and password field contains garbage value. important attributes of this table are login_id, password, email, status and user_src. user_src field value ‘0’ represents internal user while ‘1’ represents external users. external users are users synced from external sources i.e  (UNIX/LDAP/AD)

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6first_namevarchar1,022 YESMUL
    7 last_namevarchar1,022 YES 
    8 pub_scr_namevarchar2,048 YES 
    9login_idvarchar767 YESUNI
    10passwordvarchar512 NO 
    11emailvarchar512 YESUNI
    12statusint 0NO 
    13user_srcint 0NO 
    14notesvarchar4,000 YES 



  2. x_portal_user_role
    DescriptionThis table contains role details of users. An user roles may be ‘ROLE_SYS_ADMIN’ or ‘ROLE_USER’. user_id of this table is a foreign key of x_portal_user(ID)

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6user_idbigint  NOMUL
    7user_rolevarchar128 YES 
    8statusint 0NO 


  3. x_asset
    Description: This table contains details of repository. important attributes of this table are asset_name, asset_type, act_status, config. config field contains json string for repo configuration.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6asset_namevarchar1,024 NO 
    7descrvarchar4,000 NO 
    8act_statusint 0NO 
    9asset_typeint 0NO 
    10configmediumtext1,67,77,215 YES 
    11sup_nativetinyint 0NO 
  4. x_auth_sess
    Description:This table contains event details of authenticated and failed sessions. important attribute are login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip. 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6login_idvarchar767 NO 
    7user_idbigint  YESMUL
    8ext_sess_idvarchar512 YES 
    9auth_timedatetime  NO 
    10auth_statusint 0NO 
    11auth_typeint 0NO 
    12auth_providerint 0NO 
    13device_typeint 0NO 
    14req_ipvarchar48 NO 
    15req_uavarchar1,024 YES 


  5. x_cred_store
    Description:This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6store_namevarchar1,024 NO 
    7descrvarchar4,000 NO 


  6. x_db_base
    Description: This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
  7. x_group
    Description:This table contains group details. important attribute of this table are group_name, status, group_type, group_src.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6group_namevarchar1,024 NO 
    7descrvarchar4,000 NO 
    8statusint 0NO 
    9group_typeint 0NO 
    10cred_store_idbigint  YESMUL
    11group_srcint 0NO 


  8. x_group_groups
    Description: This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6group_namevarchar1,024 NO 
    7p_group_idbigint  YESMUL
    8group_idbigint  YESMUL


  9. x_user
    Description: This table contains Ranger Admin users. it also contains user synced from external sources. important attributes of this table are username, status.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6user_namevarchar1,024 NO 
    7descrvarchar4,000 NO 
    8statusint 0NO 
    9cred_store_idbigint  YESMUL


  10. x_group_users
    Description:This table contain mapping of users and groups. important attributes of this table are group_name, p_group_id, user_id

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6group_namevarchar1,024 NO 
    7p_group_idbigint  YESMUL
    8user_idbigint  YESMUL

     

  11. x_policy_export_audit 
    Description: This table contains logs of policy export request. Important attributes of this table are client_ip, agent_id, req_epoch, repository_name, exported_json, http_ret_code.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6client_ipvarchar255 NO 
    7agent_idvarchar255 YES 
    8req_epochbigint  NO 
    9last_updateddatetime  YES 
    10repository_namevarchar1,024 YES 
    11exported_jsontext65,535 YES 
    12http_ret_codeint 0NO 

     

  12. x_resource
    Description: This table contains policy information of repositories. A policy contains resources. different type of repositories may have resources in different format. Important attribute of this table are res_name, res_type, asset_id, parent_id, parent_path, is_encrypt, is_recursive, res_group, res_dbs, res_tables, res_col_fams, res_cols, res_udfs, res_status, table_type, col_type, policy_name, res_topologies, res_services.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6res_namevarchar4,000 YES 
    7descrvarchar4,000 YES 
    8res_typeint 0NO 
    9asset_idbigint  NOMUL
    10parent_idbigint  YESMUL
    11parent_pathvarchar4,000 YES 
    12is_encryptint 0NO 
    13is_recursiveint 0NO 
    14res_groupvarchar1,024 YES 
    15res_dbstext65,535 YES 
    16res_tablestext65,535 YES 
    17res_col_famstext65,535 YES 
    18res_colstext65,535 YES 
    19res_udfstext65,535 YES 
    20res_statusint 1NO 
    21table_typeint 0NO 
    22col_typeint 0NO 
    23policy_namevarchar500 YESUNI
    24res_topologiestext65,535 YES 
    25res_servicestext65,535 YES 

     

  13. x_trx_log
    Description: This table contains logs of all CRUD operation done by user. Important attribute of this table are object_name, attr_name, prev_val, new_val, trx_id, action, sess_id.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6class_typeint 0NO 
    7object_idbigint  YES 
    8parent_object_idbigint  YES 
    9parent_object_class_typeint 0NO 
    10parent_object_namevarchar1,024 YES 
    11object_namevarchar1,024 YES 
    12attr_namevarchar255 YES 
    13prev_valmediumtext1,67,77,215 YES 
    14new_valmediumtext1,67,77,215 YES 
    15trx_idvarchar1,024 YES 
    16actionvarchar255 YES 
    17sess_idvarchar512 YES 
    18req_idvarchar30 YES 
    19sess_typevarchar30 YES 
  14. x_perm_map
    Description: This table contains users and groups permission mapping on resources. Important attribute are perm_group, res_id, group_id, user_id, perm_for, perm_type, is_recursive. 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6perm_groupvarchar1,024 YES 
    7res_idbigint  YESMUL
    8group_idbigint  YESMUL
    9user_idbigint  YESMUL
    10perm_forint 0NO 
    11perm_typeint 0NO 
    12is_recursiveint 0NO 
    13is_wild_cardtinyint 1NO 
    14grant_revoketinyint 1NO 
    15ip_addresstext65,535 YES

     

     

  15. x_audit_map
    Description: This table contains users and groups audit rights mapping on resources. Important attribute are res_id, group_id, user_id, audit_type.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6res_idbigint  YESMUL
    7group_idbigint  YESMUL
    8user_idbigint  YESMUL
    9audit_typeint 0NO 

     

  16. x_db_version_h
    Description: This table contains entry of sql patches executed after creation of core schema.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2versionvarchar64 NO 
    3inst_attimestamp CURRENT_TIMESTAMPNO 
    4inst_byvarchar256 NO 
    5updated_attimestamp 0000-00-00 00:00:00NO 
    6updated_byvarchar256 NO 
    7activeenum1YYES 

     

  17. xa_access_audit
    Description: This table contains entries of audit event done by users on resource of configured repositories. A resource could be HDFS/HIVE/HDFS/Knox/Storm resource. Important attribute of this table are audit_type, access_result, access_type, acl_enforcer, agent_id, client_ip, client_type, policy_id, repo_name, repo_type, result_reason, session_id, event_time, request_user, action, request_data, resource_path, resource_type.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint  NOPRI
    2create_timedatetime  YESMUL
    3update_timedatetime  YESMUL
    4added_by_idbigint  YESMUL
    5upd_by_idbigint  YESMUL
    6audit_typeint 0NO 
    7access_resultint 0YES 
    8access_typevarchar255 YES 
    9acl_enforcervarchar255 YES 
    10agent_idvarchar255 YES 
    11client_ipvarchar255 YES 
    12client_typevarchar255 YES 
    13policy_idbigint 0YES 
    14repo_namevarchar255 YES 
    15repo_typeint 0YES 
    16result_reasonvarchar255 YES 
    17session_idvarchar255 YES 
    18event_timedatetime  YESMUL
    19request_uservarchar255 YES 
    20actionvarchar2,000 YES 
    21request_datavarchar2,000 YES 
    22resource_pathvarchar2,000 YES 
    23resource_typevarchar255 YES 

     

  18. vx_trx_log
    Description:  This is a view created from x_trx_log table. schema definition of view is:  CREATE VIEW vx_trx_log AS select x_trx_log.id AS id,x_trx_log.create_time AS create_time,x_trx_log.update_time AS update_time,x_trx_log.added_by_id AS added_by_id,x_trx_log.upd_by_id AS upd_by_id,x_trx_log.class_type AS class_type,x_trx_log.object_id AS object_id,x_trx_log.parent_object_id AS parent_object_id,x_trx_log.parent_object_class_type AS parent_object_class_type,x_trx_log.attr_name AS attr_name,x_trx_log.parent_object_name AS parent_object_name,x_trx_log.object_name AS object_name,x_trx_log.prev_val AS prev_val,x_trx_log.new_val AS new_val,x_trx_log.trx_id AS trx_id,x_trx_log.action AS action,x_trx_log.sess_id AS sess_id,x_trx_log.req_id AS req_id,x_trx_log.sess_type AS sess_type from x_trx_log  where id in(select min(x_trx_log.id) from x_trx_log group by x_trx_log.trx_id);

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint 0NO 
    2create_timedatetime  YES 
    3update_timedatetime  YES 
    4added_by_idbigint  YES 
    5upd_by_idbigint  YES 
    6class_typeint 0NO 
    7object_idbigint  YES 
    8parent_object_idbigint  YES 
    9parent_object_class_typeint 0NO 
    10attr_namevarchar255 YES 
    11parent_object_namevarchar1,024 YES 
    12object_namevarchar1,024 YES 
    13prev_valmediumtext1,67,77,215 YES 
    14new_valmediumtext1,67,77,215 YES 
    15trx_idvarchar1,024 YES 
    16actionvarchar255 YES 
    17sess_idvarchar512 YES 
    18req_idvarchar30 YES 
    19sess_typevarchar30 YES 

ORACLE

  1. x_portal_user
    Description: This table contains user profile and credentials of Ranger Admin users. it also contains user synced from external sources but credential are not stored and password field contains garbage value. important attributes of this table are login_id, password, email, status and user_src. user_src field value ‘0’ represents internal user while ‘1’ represents external users. external users are users synced from external sources i.e  (UNIX/LDAP/AD) 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6FIRST_NAMEVARCHAR2256NULLY
    7LAST_NAMEVARCHAR2256NULLY
    8PUB_SCR_NAMEVARCHAR22,048NULLY
    9LOGIN_IDVARCHAR2767NULLY
    10PASSWORDVARCHAR2512 N
    11EMAILVARCHAR2512NULLY
    12STATUSNUMBER220'N
    13USER_SRCNUMBER220'N
    14NOTESVARCHAR24,000NULLY

     

  2. x_portal_user_role
    Description: This table contains role details of users. An user roles may be ‘ROLE_SYS_ADMIN’ or ‘ROLE_USER’. user_id of this table is a foreign key of x_portal_user(ID).

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6USER_IDNUMBER22 N
    7USER_ROLEVARCHAR2128NULLY
    8STATUSNUMBER220N


  3. x_asset
    Description: This table contains details of repository. important attributes of this table are asset_name, asset_type, act_status, config. config field contains json string for repo configuration. 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6ASSET_NAMEVARCHAR21,024 N
    7DESCRVARCHAR24,000NULLY
    8ACT_STATUSNUMBER220'N
    9ASSET_TYPENUMBER220'N
    10CONFIGCLOB4,000 Y
    11SUP_NATIVENUMBER220'N


  4. x_auth_sess

    Description: This table contains event details of authenticated and failed sessions. important attribute are login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6LOGIN_IDVARCHAR2767 N
    7USER_IDNUMBER22NULLY
    8EXT_SESS_IDVARCHAR2512NULLY
    9AUTH_TIMEDATE7 N
    10AUTH_STATUSNUMBER220'N
    11AUTH_TYPENUMBER220'N
    12AUTH_PROVIDERNUMBER220'N
    13DEVICE_TYPENUMBER220'N
    14REQ_IPVARCHAR248 N
    15REQ_UAVARCHAR21,024NULLY


  5. x_cred_store
    Description: This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6STORE_NAMEVARCHAR21,024 N
    7DESCRVARCHAR24,000 N


  6. x_db_base
    Description: This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY


  7. x_group
    Description: This table contains group details. important attribute of this table are group_name, status, group_type, group_src.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6GROUP_NAMEVARCHAR21,024 N
    7DESCRVARCHAR24,000NULLY
    8STATUSNUMBER220'N
    9GROUP_TYPENUMBER220'N
    10CRED_STORE_IDNUMBER22NULLY
    11GROUP_SRCNUMBER220N


  8. x_group_groups
    Description: This table is not in use and might be required in future.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6GROUP_NAMEVARCHAR21,024 N
    7P_GROUP_IDNUMBER22NULLY
    8GROUP_IDNUMBER22NULLY


  9. x_user
    Description: This table contains Ranger Admin users. it also contains user synced from external sources. important attributes of this table are username, status.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6USER_NAMEVARCHAR21,024 N
    7DESCRVARCHAR24,000NULLY
    8STATUSNUMBER220'N
    9CRED_STORE_IDNUMBER22NULLY


  10. x_group_users
    Decsription:  This table contain mapping of users and groups. important attributes of this table are group_name, p_group_id, user_id

     

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6GROUP_NAMEVARCHAR21,024 N
    7P_GROUP_IDNUMBER22NULLY
    8USER_IDNUMBER22NULLY
  11. x_policy_export_audit
    Description: This table contains logs of policy export request. Important attributes of this table are client_ip, agent_id, req_epoch, repository_name, exported_json, http_ret_code.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6CLIENT_IPVARCHAR2255 N
    7AGENT_IDVARCHAR2255NULLY
    8REQ_EPOCHNUMBER22 N
    9LAST_UPDATEDDATE7NULLY
    10REPOSITORY_NAMEVARCHAR21,024NULLY
    11EXPORTED_JSONCLOB4,000 Y
    12HTTP_RET_CODENUMBER220'N


  12. x_resource
    Description: This table contains policy information of repositories. A policy contains resources. different type of repositories may have resources in different format. Important attribute of this table are res_name, res_type, asset_id, parent_id, parent_path, is_encrypt, is_recursive, res_group, res_dbs, res_tables, res_col_fams, res_cols, res_udfs, res_status, table_type, col_type, policy_name, res_topologies, res_services.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6RES_NAMEVARCHAR24,000NULLY
    7DESCRVARCHAR24,000NULLY
    8RES_TYPENUMBER220'N
    9ASSET_IDNUMBER22 N
    10PARENT_IDNUMBER22NULLY
    11PARENT_PATHVARCHAR24,000NULLY
    12IS_ENCRYPTNUMBER220'N
    13IS_RECURSIVENUMBER220'N
    14RES_GROUPVARCHAR21,024NULLY
    15RES_DBSCLOB4,000 Y
    16RES_TABLESCLOB4,000 Y
    17RES_COL_FAMSCLOB4,000 Y
    18RES_COLSCLOB4,000 Y
    19RES_UDFSCLOB4,000 Y
    20RES_STATUSNUMBER221'N
    21TABLE_TYPENUMBER220'N
    22COL_TYPENUMBER220'N
    23POLICY_NAMEVARCHAR2500NULLY
    24RES_TOPOLOGIESCLOB4,000NULLY
    25RES_SERVICESCLOB4,000NULLY


  13. x_trx_log
    Description: This table contains logs of all CRUD operation done by user. Important attribute of this table are object_name, attr_name, prev_val, new_val, trx_id, action, sess_id.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6CLASS_TYPENUMBER220'N
    7OBJECT_IDNUMBER22NULLY
    8PARENT_OBJECT_IDNUMBER22NULLY
    9PARENT_OBJECT_CLASS_TYPENUMBER220'N
    10PARENT_OBJECT_NAMEVARCHAR21,024NULLY
    11OBJECT_NAMEVARCHAR21,024NULLY
    12ATTR_NAMEVARCHAR2255NULLY
    13PREV_VALCLOB4,000NULLY
    14NEW_VALCLOB4,000NULLY
    15TRX_IDVARCHAR21,024NULLY
    16ACTIONVARCHAR2255NULLY
    17SESS_IDVARCHAR2512NULLY
    18REQ_IDVARCHAR230NULLY
    19SESS_TYPEVARCHAR230NULLY


  14. x_perm_map
    Description: This table contains users and groups permission mapping on resources. Important attribute are perm_group, res_id, group_id, user_id, perm_for, perm_type, is_recursive.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6PERM_GROUPVARCHAR21,024NULLY
    7RES_IDNUMBER22NULLY
    8GROUP_IDNUMBER22NULLY
    9USER_IDNUMBER22NULLY
    10PERM_FORNUMBER220'N
    11PERM_TYPENUMBER220'N
    12IS_RECURSIVENUMBER220'N
    13IS_WILD_CARDNUMBER221'N
    14GRANT_REVOKENUMBER221'N
    15IP_ADDRESSCLOB4,000NULLY


  15. x_audit_map
    Description: This table contains users and groups audit rights mapping on resources. Important attribute are res_id, group_id, user_id, audit_type.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6RES_IDNUMBER22NULLY
    7GROUP_IDNUMBER22NULLY
    8USER_IDNUMBER22NULLY
    9AUDIT_TYPENUMBER220N


  16. x_db_version_h
    Description: This table contains entry of sql patches executed after creation of core schema.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2VERSIONVARCHAR264 N
    3INST_ATDATE7SYSDATEN
    4INST_BYVARCHAR2256 N
    5UPDATED_ATDATE7SYSDATEN
    6UPDATED_BYVARCHAR2256 N
    7ACTIVEVARCHAR21Y'Y


  17. xa_access_audit
    Description: This table contains entries of audit event done by users on resource of configured repositories. A resource could be HDFS/HIVE/HDFS/Knox/Storm resource. Important attribute of this table are audit_type, access_result, access_type, acl_enforcer, agent_id, client_ip, client_type, policy_id, repo_name, repo_type, result_reason, session_id, event_time, request_user, action, request_data, resource_path, resource_type.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7NULLY
    3UPDATE_TIMEDATE7NULLY
    4ADDED_BY_IDNUMBER22NULLY
    5UPD_BY_IDNUMBER22NULLY
    6AUDIT_TYPENUMBER220'N
    7ACCESS_RESULTNUMBER220'Y
    8ACCESS_TYPEVARCHAR2255NULLY
    9ACL_ENFORCERVARCHAR2255NULLY
    10AGENT_IDVARCHAR2255NULLY
    11CLIENT_IPVARCHAR2255NULLY
    12CLIENT_TYPEVARCHAR2255NULLY
    13POLICY_IDNUMBER220'Y
    14REPO_NAMEVARCHAR2255NULLY
    15REPO_TYPENUMBER220'Y
    16RESULT_REASONVARCHAR2255NULLY
    17SESSION_IDVARCHAR2255NULLY
    18EVENT_TIMEDATE7NULLY
    19REQUEST_USERVARCHAR2255NULLY
    20ACTIONVARCHAR22,000NULLY
    21REQUEST_DATAVARCHAR22,000NULLY
    22RESOURCE_PATHVARCHAR22,000NULLY
    23RESOURCE_TYPEVARCHAR2255NULLY


  18. vx_trx_log
    Description: This is a view created from x_trx_log table. schema definition of view is
    CREATE VIEW vx_trx_log AS select x_trx_log.id AS id,x_trx_log.create_time AS create_time,x_trx_log.update_time AS update_time,x_trx_log.added_by_id AS added_by_id,x_trx_log.upd_by_id AS upd_by_id,x_trx_log.class_type AS class_type,x_trx_log.object_id AS object_id,x_trx_log.parent_object_id AS parent_object_id,x_trx_log.parent_object_class_type AS parent_object_class_type,x_trx_log.attr_name AS attr_name,x_trx_log.parent_object_name AS parent_object_name,x_trx_log.object_name AS object_name,x_trx_log.prev_val AS prev_val,x_trx_log.new_val AS new_val,x_trx_log.trx_id AS trx_id,x_trx_log.action AS action,x_trx_log.sess_id AS sess_id,x_trx_log.req_id AS req_id,x_trx_log.sess_type AS sess_type from x_trx_log  where id in(select min(x_trx_log.id) from x_trx_log group by x_trx_log.trx_id);

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLE
    1IDNUMBER22 N
    2CREATE_TIMEDATE7 Y
    3UPDATE_TIMEDATE7 Y
    4ADDED_BY_IDNUMBER22 Y
    5UPD_BY_IDNUMBER22 Y
    6CLASS_TYPENUMBER22 N
    7OBJECT_IDNUMBER22 Y
    8PARENT_OBJECT_IDNUMBER22 Y
    9PARENT_OBJECT_CLASS_TYPENUMBER22 N
    10ATTR_NAMEVARCHAR2255 Y
    11PARENT_OBJECT_NAMEVARCHAR21,024 Y
    12OBJECT_NAMEVARCHAR21,024 Y
    13PREV_VALCLOB4,000 Y
    14NEW_VALCLOB4,000 Y
    15TRX_IDVARCHAR21,024 Y
    16ACTIONVARCHAR2255 Y
    17SESS_IDVARCHAR2512 Y
    18REQ_IDVARCHAR230 Y
    19SESS_TYPEVARCHAR230 Y

 

  • No labels