You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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


  1. x_db_version_h

    Description: This table contains entry of java patches and 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
    CURRENT_TIMESTAMPNO
    6updated_byvarchar256
    NO
    7activeenum1YYES
  2. x_portal_user


    Description
    : 
    This table contains user profile and credentials of Ranger Admin users. It also contains users synced from external sources but credentials 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 user. External users are users synced from external sources i.e  (UNIX / LDAP / AD).
     

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    create_time

    datetime



    YES

    MUL

    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint



    YES

    MUL

    5

    upd_by_id

    bigint



    YES

    MUL

    6

    first_name

    varchar

    1,022


    YES

    MUL

    7

    last_name

    varchar

    1,022


    YES


    8

    pub_scr_name

    varchar

    2,048


    YES


    9

    login_id

    varchar

    767


    YES

    UNI

    10

    password

    varchar

    512


    NO


    11

    email

    varchar

    512


    YES

    UNI

    12

    status

    integer


    0

    NO


    13

    user_src

    integer


    0

    NO


    14

    notes

    varchar

    4,000


    YES


    15

    other_attributes

    varchar

    4,000


    YES


  3. x_portal_user_role 


     
    Description:
     This table contains role details of users. User roles may be ‘ROLE_SYS_ADMIN’, ‘ROLE_USER’, ‘ROLE_KEY_ADMIN’, 'ROLE_ADMIN_AUDITOR', 'ROLE_KEY_ADMIN_AUDITOR' user_id of this table is a foreign key of x_portal_user(ID). 

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    create_time

    datetime



    YES

    MUL

    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint



    YES

    MUL

    5

    upd_by_id

    bigint



    YES

    MUL

    6

    user_id

    bigint



    NO

    MUL

    7

    user_role

    varchar

    128


    YES


    8statusinteger
    0NO
  4. xa_access_audit 

    Description:  This table contains entries of audit event done by users on resource of configured repositories.

     Note: This table has been kept just for backward compatibility. Audit to DB feature has been discontinued. 

    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_typeinteger
    0NO
    7access_resultinteger
    0YES
    8access_typevarchar255
    YES
    9acl_enforcervarchar255
    YES
    10agent_idvarchar255
    YES
    11client_ipvarchar255
    YES
    12client_typevarchar255
    YES
    13policy_idbigint
    0YES
    14repo_namevarchar255
    YES
    15repo_typeinteger
    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
    24seq_numbigint
    0YES
    25event_countbigint
    1YES
    26event_dur_msbigint
    1YES
  5. x_asset

    Note: This table is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_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_statusinteger
    0NO
    9asset_typeinteger
    0NO
    10configmediumtext1,67,77,215
    YES
    11sup_nativetinyint
    0NO
  6. x_auth_sess

    Description: This table contains event details of authenticated and failed sessions. Important attributes are login_id, ext_sess_id, auth_time, auth_status, auth_type, auth_provider, req_ip. If user has Ranger installed for long duration, this table will get filled with large number of session entries. 

    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_statusinteger
    0NO
    11auth_typeinteger
    0NO
    12auth_providerinteger
    0NO
    13device_typeinteger
    0NO
    14req_ipvarchar48
    NO
    15req_uavarchar1,024
    YES
  7. x_cred_store 

    Note: This table is not in use and might not be required in future. It is available to support upgrade scenarios.


    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
  8. x_db_base

    Note: This table is not in use and might not be required in future.It is available to support upgrade scenarios.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2create_timedatetime

    YESMUL
    3update_timedatetime

    YESMUL
    4added_by_idbigint

    YESMUL
    5upd_by_idbigint

    YESMUL
  9. x_group

     Description: This table contains group details. Important attributes of this table are group_name, status, group_type, group_src. Additional column is_visible is added to hide / unhide a group in Ranger UI.

    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_namevarchar767
    NO
    7descrvarchar4,000
    NO
    8statusinteger
    0NO
    9group_typeinteger
    0NO
    10cred_store_idbigint

    YESMUL
    11group_srcinteger
    0NO
    12is_visibleinteger
    1NO
    13other_attributesvarchar4000
    YES
  10. x_group_groups

    Note: This table is not in use and will not be required in future. It is available to support upgrade scenarios.

    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
  11. x_user

    Description: This table contains Ranger Admin users, it also contains users synced from external sources. Important attributes of this table are username, status. Additional column is_visible is added to hide/unhide a user in Ranger UI.

    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_namevarchar767
    NO
    7descrvarchar4,000
    NO
    8statusinteger
    0NO
    9cred_store_idbigint

    YESMUL
    10is_visibleinteger
    1NO
    11other_attributesvarchar4000
    YES
  12. 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. `p_group_id` refers to `x_group.id` and `user_id` refers to `x_user.id`

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    create_time

    datetime



    YES

    MUL

    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint



    YES

    MUL

    5

    upd_by_id

    bigint



    YES

    MUL

    6

    group_name

    varchar

    740


    NO


    7

    p_group_id

    bigint



    YES

    MUL

    8

    user_id

    bigint



    YES

    UL

  13. 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_codeinteger
    0NO
    13cluster_namevarchar255
    YES
    14zone_namevarchar255
    YES
    15policy_versionbigint

    YES
  14. x_resource

    Description: This table contains policy information of repositories. A policy contains resources, different types of repositories may have resources in different format. Important attributes 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. 

    Note: This table is not in use anymore.  It is available to support upgrade scenarios.

    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_typeinteger
    0NO
    9asset_idbigint

    NOMUL
    10parent_idbigint

    YESMUL
    11parent_pathvarchar4,000
    YES
    12is_encryptinteger
    0NO
    13is_recursiveinteger
    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_statusinteger
    1NO
    21table_typeinteger
    0NO
    22col_typeinteger
    0NO
    23policy_namevarchar500
    YESUNI
    24res_topologiestext65,535
    YES
    25res_servicestext65,535
    YES
  15. x_trx_log

    Description: This table contains logs of all CRUD operation done by user. Admin audits are retrieved from this table. 
    Important attributes of this table are object_name, attr_name, prev_val, new_val, trx_id, action, sess_id.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    create_time

    datetime



    YES

    MUL

    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint



    YES

    MUL

    5

    upd_by_id

    bigint



    YES

    MUL

    6

    class_type

    integer


    0

    NO


    7

    object_id

    bigint



    YES


    8

    parent_object_id

    bigint



    YES


    9

    parent_object_class_type

    integer


    0

    NO


    10

    parent_object_name

    varchar

    1,024


    YES


    11

    object_name

    varchar

    1,024


    YES


    12

    attr_name

    varchar

    255


    YES


    13

    prev_val

    mediumtext

    1,67,77,215


    YES


    14

    new_val

    mediumtext

    1,67,77,215


    YES


    15

    trx_id

    varchar

    1,024


    YES


    16

    action

    varchar

    255


    YES


    17

    sess_id

    varchar

    512


    YES


    18

    req_id

    varchar

    30


    YES


    19

    sess_type

    varchar

    30


    YES


  16. x_perm_map

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

    Note: It is not used anymore. It is available to support upgrade scenarios.

    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_forinteger
    0NO
    11perm_typeinteger
    0NO
    12is_recursiveinteger
    0NO
    13is_wild_cardtinyint
    1NO
    14grant_revoketinyint
    1NO
    15ip_addresstext65,535
    YES
  17. x_audit_map 

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

    Note: It is not used anymore. It is available to support upgrade scenarios.

    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_typeinteger
    0NO
  18. x_service_def

    Description: (This table added to Enable Pluggable service model in Ranger). This table contains metadata of services. Service definition of different Hadoop components can be stored as a template for defining services of specific hadoop component. Important attributes of this table are: version, name, impl_class_name, label, is_enabled.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YESMUL
    4update_timedatetime

    YESMUL
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7versionbigint

    YES
    8namevarchar1,024
    YES
    9display_namevarchar1024
    YES
    10impl_class_namevarchar1,024
    YES
    11labelvarchar1,024
    YES
    12descriptionvarchar1,024
    YES
    13rb_key_labelvarchar1,024
    YES
    14rb_key_descriptionvarchar1,024
    YES
    15is_enabledtinyint
    1YES
    16def_optionsvarchar1024
    YES
  19. x_service

    Description: (Table added to Enable Pluggable service model in Ranger). This table contains services information. Important attributes of this table are: version, type, name, policy_version, is_enabled. 'type' column is reference of 'x_service_def.id' column.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YESMUL
    4update_timedatetime

    YESMUL
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7versionbigint

    YES
    8typebigint

    YESMUL
    9namevarchar255
    YESUNI
    10display_namevarchar255
    YES
    11policy_versionbigint

    YES
    12policy_update_timedatetime

    YES
    13descriptionvarchar1,024
    YES
    14is_enabledtinyint
    0NO
    15tag_servicebigint

    YES
    16tag_versionbigint
    0YES
    17tag_update_timedatetime

    YES
  20. x_security_zone

    Description: This table contains Ranger security zone details. Important attributes of this table are version, name, jsonData, description.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    version

    bigint

    20


    YES


    7

    name

    varchar

    255


    NO

    UNI

    8

    jsonData

    mediumtext



    YES


    9

    description

    varchar

    1024


    YES



  21. x_ranger_global_state

    Description: This table contains ranger newly added elements ranger state related information like Ranger Role, Ranger User Store, Ranger Security Zone. Important Attributes are : version, state_name, app_data. state_name contains actual elements name, app_data contains version count after addition of new state in ranger.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    updated_by_id

    bigint

    20


    YES

    MUL

    6

    version

    bigint

    20


    YES


    7

    state_name

    varchar

    255


    NO

    UNI

    8

    app_data

    varchar

    255


    YES


  22. x_security_zone_ref_service

    Description: This table contains entries of service details assigned under Ranger security zone. Important attributes are : zone_id, service_id, service_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'service_id' is foreign key column of 'x_service.id' and the service_name contains the name of the service.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    zone_id

    bigint

    20


    YES

    MUL

    7

    service_id

    bigint

    20


    YES

    MUL

    8

    service_name

    varchar

    255


    YES

    MUL

  23. x_security_zone_ref_tag_srvc

    Description: This table contains entries of tag services details assigned under Ranger security zone. Important attributes are : zone_id, tag_srvc_id, tag_srvc_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'tag_srvc_id' is foreign key column of 'x_service.id',  'tag_srvc_name' is foreign key column of 'x_service.name'.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    zone_id

    bigint

    20


    YES

    MUL

    7

    tag_srvc_id

    bigint

    20


    YES

    MUL

    8

    tag_srvc_name

    varchar

    255


    YES

    MUL

  24. x_security_zone_ref_user

    Description: This table contains entries of user details assigned under Ranger security zone. Important attributes are : zone_id, user_id, user_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'user_id' is foreign key column of 'x_user.id' and the user_name contains the name of the user.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    zone_id

    bigint

    20


    YES

    MUL

    7

    user_id

    bigint

    20


    YES

    MUL

    8

    user_name

    varchar

    255


    YES

    MUL

    9

    user_type

    tinyint

    3


    YES


  25. x_security_zone_ref_group

    Description: This table contains entries of group details assigned under Ranger security zone. Important attributes are : zone_id, group_id, group_name, group_type. 'zone_id' is foreign key column of 'x_security_zone.id', 'group_id' is foreign key column of 'x_group.id' and the group_name contains the name of the group.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    zone_id

    bigint

    20


    YES

    MUL

    7

    group_id

    bigint

    20


    YES

    MUL

    8

    group_name

    varchar

    255


    YES


    9

    group_type

    tinyint

    3


    YES


  26. x_policy 

    Description: (Table added to Enable Pluggable service model in Ranger). 

    This table contains policies details of policies. Important attributes are service, name, policy_type, resource_signature, is_enabled,policy_text. 'service' column is foreign key of 'x_service.id' column.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YESMUL
    4update_timedatetime

    YESMUL
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7versionbigint

    YES
    8servicebigint

    YESMUL
    9namevarchar512
    YES
    10policy_typeinteger
    0YES
    11descriptionvarchar1,024
    YES
    12resource_signaturevarchar128
    YESMUL
    13is_enabledtinyint
    0NO
    14is_audit_enabledtinyint
    0NO
    15policy_optionsvarchar4000
    YES
    16policy_priorityint
    0NO
    17policy_textmedium_text

    YES
    18zone_idbigint

    NO
  27. x_service_config_def

    Description : 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7def_idbigint

    NOMUL
    8item_idbigint

    NO
    9namevarchar1,024
    YES
    10typevarchar1,024
    YES
    11sub_typevarchar1,024
    YES
    12is_mandatorytinyint
    0NO
    13default_valuevarchar1,024
    YES
    14validation_reg_exvarchar1,024
    YES
    15validation_messagevarchar1,024
    YES
    16ui_hintvarchar1,024
    YES
    17labelvarchar1,024
    YES
    18descriptionvarchar1,024
    YES
    19rb_key_labelvarchar1,024
    YES
    20rb_key_descriptionvarchar1,024
    YES
    21rb_key_validation_messagevarchar1,024
    YES
    22sort_ordertinyint
    0YES
  28. x_resource_def

    Description: (Table added to Enable Pluggable service model in Ranger)

    This table contains definitions of resources of each type of services. Important attributes are : def_id, item_id, name, type, res_level, parent, mandatory, look_up_supported, recursive_supported, excludes_supported, matcher, matcher_options, validation_reg_ex, validation_message, ui_hint, label, description, sort_order. 'def_id' is foreign key reference of 'x_service_def.id' column, 'item_id' is the sequence number of each items created under each service definitions. 'name' column contains resource def name (i.e path, column, table, topology). 'type' column is data-type of name (i.e path type for path). 'parent' is foreign key of 'id' column i.e if 'name' is of type ‘column’ then its parent would be table. 'matcher' contains matcher class name, 'matcher_options' contains key-value pair for matchers. i.e {"wildCard":"true", "ignoreCase":"YES"}.  'label' contains label value to be displayed in UI for name column.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    guid

    varchar

    1,024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint



    YES

    MUL

    6

    upd_by_id

    bigint



    YES

    MUL

    7

    def_id

    bigint



    NO

    MUL

    8

    item_id

    bigint



    NO


    9

    name

    varchar

    1,024


    YES


    10

    type

    varchar

    1,024


    YES


    11

    res_level

    bigint



    YES


    12

    parent

    bigint



    YES

    MUL

    13

    mandatory

    tinyint


    0

    NO


    14

    look_up_supported

    tinyint


    0

    NO


    15

    recursive_supported

    tinyint


    0

    NO


    16

    excludes_supported

    tinyint


    0

    NO


    17

    matcher

    varchar

    1,024


    YES


    18

    matcher_options

    varchar

    1,024


    YES


    19

    validation_reg_ex

    varchar

    1,024


    YES


    20

    validation_message

    varchar

    1,024


    YES


    21

    ui_hint

    varchar

    1,024


    YES


    22

    label

    varchar

    1,024


    YES


    23

    description

    varchar

    1,024


    YES


    24

    rb_key_label

    varchar

    1,024


    YES


    25

    rb_key_description

    varchar

    1,024


    YES


    26

    rb_key_validation_message

    varchar

    1,024


    YES


    27

    sort_order

    tinyint


    0

    YES


    28datamask_optionsvarchar1024
    YES
    29rowfilter_optionsvarchar1024
    YES
  29. x_access_type_def

     Description: (Table added to Enable Pluggable service model in Ranger). This table contains definitions of access types(i.e read, write). Important attributes are def_id, item_id, name, label, rb_key_label, sort_order.def_id is foreign key of x_service_def.id table. item_id is sequence number of access_type entries under each service def. name fields denotes access type names(i.e read, write, execute). 'label' field contains label value that needs to be displayed in UI for name column.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    guid

    varchar

    1,024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint



    YES

    MUL

    6

    upd_by_id

    bigint



    YES

    MUL

    7

    def_id

    bigint



    NO

    MUL

    8

    item_id

    bigint



    NO


    9

    name

    varchar

    1,024


    YES


    10

    label

    varchar

    1,024


    YES


    11

    rb_key_label

    varchar

    1,024


    YES


    12

    sort_order

    tinyint


    0

    YES


    13datamask_optionsvarchar1024
    YES
    14rowfilter_optionsvarchar1024
    YES
  30. x_access_type_def_grants

    Description: (Table added to Enable Pluggable service model in Ranger). This table contains entries of access types which can have grants. Important attributes are atd_id, implied_grant. atd_id is foreign key of x_access_type_def.id

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7atd_idbigint

    NOMUL
    8implied_grantvarchar1,024
    YES
  31.  x_policy_condition_def 

    Description: This table contains conditions which need to be applied in policy (i.e IP address range). Important attributes of this table are def_iditem_id, name, evaluator, evaluator_options, validation_reg_ex, validation_message, ui_hint, label, description, sort_order.'def_id' is foreign key of 'x_service_def.id' column. 'item_id' contains policy condition sequence number under each service def. 'name' denotes condition name. 'evaluator' contains condition evaluator class name. 

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    guid

    varchar

    1,024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint



    YES

    MUL

    6

    upd_by_id

    bigint



    YES

    MUL

    7

    def_id

    bigint



    NO

    MUL

    8

    item_id

    bigint



    NO


    9

    name

    varchar

    1,024


    YES


    10

    evaluator

    varchar

    1,024


    YES


    11

    evaluator_options

    varchar

    1,024


    YES


    12

    validation_reg_ex

    varchar

    1,024


    YES


    13

    validation_message

    varchar

    1,024


    YES


    14

    ui_hint

    varchar

    1,024


    YES


    15

    label

    varchar

    1,024


    YES


    16

    description

    varchar

    1,024


    YES


    17

    rb_key_label

    varchar

    1,024


    YES


    18

    rb_key_description

    varchar

    1,024


    YES


    19

    rb_key_validation_message

    varchar

    1,024


    YES


    20sort_ordertinyint
    0YES
  32. x_context_enricher_def  

    Description: Same as policy-condition but enrichers will enrich policies by taking input from outside the system and user don’t need to provide any condition in policy. Important fields are 'name' and 'enricher'. Name field holds the name of enricher i.e `COUNTRY` and 'enricher' field holds the class name which will be enriching policy for this particular context-enricher.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7def_idbigint

    NOMUL
    8item_idbigint

    NO
    9namevarchar1,024
    YES
    10enrichervarchar1,024
    YES
    11enricher_optionsvarchar1,024
    YES
    12sort_ordertinyint
    0YES
  33. x_enum_def

    Description: This table contains enum definitions. Important attributes are def_id, item_id, name. 'def_id' is foreign key of 'x_service_def.id' column. 'name' column denoted the enum name (i.e authnType, rpcProtection). 

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7def_idbigint

    NOMUL
    8item_idbigint

    NO
    9namevarchar1,024
    YES
    10default_indexbigint

    YES
  34. x_enum_element_def

    Description: This table contains element details of enum defined in x_enum_def table. Important attributes are enum_def_id, item_id, name, label, sort_order. enum_def_id is foreign key column of x_enum_def.id. 'name' contains enum element name (i.e simple, kerberos).

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7enum_def_idbigint

    NOMUL
    8item_idbigint

    NO
    9namevarchar1,024
    YES
    10labelvarchar1,024
    YES
    11rb_key_labelvarchar1,024
    YES
    12sort_ordertinyint
    0YES
  35. x_service_config_map

    Description: This table contains x_service_config_map. Important attributes are service, config_key, config_value. 'service' column is foreign key of 'x_service.id'. 'config_key' contains config attribute name and 'config_value' contains the value of config key field.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint



    NO

    PRI

    2

    guid

    varchar

    1,024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint



    YES

    MUL

    6

    upd_by_id

    bigint



    YES

    MUL

    7

    service

    bigint



    NO

    MUL

    8

    config_key

    varchar

    1,024


    YES


    9

    config_value

    varchar

    4,000


    YES


  36. x_policy_resource

    Description: This table contains entries of resources assigned under policy. Important attributes are : policy_id, res_def_id, is_excludes, is_recursive. 'policy_id' is foreign key column of 'x_policy.id' and 'res_def_id' is foreign key column of 'x_resource_def.id' column. 'is_excludes' flag denotes whether policy should be enforced on the mapped resources or all other resources except mapped one. 'is_recursive' flag denotes whether policy need to be enforced in child resources also or not.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7policy_idbigint

    NOMUL
    8res_def_idbigint

    NOMUL
    9is_excludestinyint
    0NO
    10is_recursivetinyint
    0NO
  37. x_policy_resource_map

    Description: This table contains entries of resources values assigned under policy. Important attributes are : resource_id, value. 'resource_id' is foreign key column of 'x_policy_resource.id' and value contains resource entries.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7resource_idbigint

    NOMUL
    8valuevarchar1,024
    YES
    9sort_ordertinyint
    0YES
  38. x_policy_item

    Description: This table contains delegated admin flag of a policy. Important attributes are policy_id, delegate_admin, sort_order. 'policy_id' is foreign key column of 'x_policy.id'. delegate_admin contains flag for whether delegated admin rights are given in policy or not.
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7policy_idbigint

    NOMUL
    8delegate_admintinyint
    0NO
    9sort_ordertinyint
    0YES
    10item_typeint
    0YES
    11is_enabledtinyint
    1NO
    12commentsvarchar255
    YES
  39. x_policy_item_access

    Description: This table contains whether specific access is allowed or not in specific policy item. Important attributes are policy_item_id, type, is_allowed. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'type' is foreign key column of 'x_access_type_def.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7policy_item_idbigint

    NOMUL
    8typebigint

    NOMUL
    9is_allowedtinyint
    0NO
    10sort_ordertinyint
    0YES
  40. x_policy_item_condition

    Description: This table contains whether specific access is allowed or not in specific policy item. Important attributes are policy_item_id, type, is_allowed. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'type' is foreign key column of 'x_policy_condition_def.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES

    MUL

    4

    update_time

    datetime



    YES

    MUL

    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    updated_by_id

    bigint

    20


    YES

    MUL

    7

    label_name

    varchar

    512


    YES

    UNI

    8typebigint

    NOMUL
    9valuevarchar1,024
    YES
    10sort_ordertinyint
    0YES
  41. x_policy_item_user_perm

    Description: This table contains mapping of policy item and user. If any user is having access to any specific policy item then corresponding entry needs to be done in the this table. Important attributes are policy_item_id, user_id. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'user_id' is foreign key of 'x_user.id'.

    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7policy_item_idbigint

    NOMUL
    8user_idbigint

    YESMUL
    9sort_ordertinyint
    0YES
  42. x_policy_item_group_perm

    Description: This table contains mapping of policy item and groups. If any group is given access to any specific policy item then corresponding entry need to be done in this  table. Important attributes are policy_item_id, group_id. 'policy_item_id' is foreign key columns of 'x_policy_item.id' and 'group_id' is foreign key of 'x_group.id'
    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2guidvarchar1,024
    YES
    3create_timedatetime

    YES
    4update_timedatetime

    YES
    5added_by_idbigint

    YESMUL
    6upd_by_idbigint

    YESMUL
    7policy_item_idbigint

    NOMUL
    8group_idbigint

    YESMUL
    9sort_ordertinyint
    0YES
  43. x_data_hist

    Description: This table contains history of create, update and delete of objects service-defs, services and policies.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2create_timedatetime

    YES
    3update_timedatetime

    YES
    4obj_guidvarchar1,024
    NO
    5obj_class_typeinteger

    NO
    6obj_idbigint

    NO
    7obj_namevarchar1,024
    NO
    8versionbigint

    YES
    9actionvarchar512
    NO
    10from_timedatetime

    NO
    11to_timedatetime

    YES
    12contenttext65,535
    NO
  44. x_modules_master

    Description: (Table added to enable Permission model in Ranger). 
    This table contain all module details available in Ranger Admin. 'module' column contain name of module. Example of modules are 1) Resource Based Policies, 2) Users/Groups, 3) Audits Module.. etc.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2create_timedatetime

    YES
    3update_timedatetime

    YES
    4added_by_idbigint

    YES
    5upd_by_idbigint

    YES
    6modulevarchar1,024
    NO
    7urlvarchar1,024
    YES
  45. x_user_module_perm 

    Description:(Table added to enable Permission model in Ranger). This table contains mapping of user and module. Important attributes are user_id, module_id, is_allowed. 'user_id' is foreign key of 'x_portal_user.id' and 'module_id' is foreign key of 'x_modules_master.id' column. 'is_allowed' column value denotes whether a user has access to mapped user or not.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2user_idbigint

    YESMUL
    3module_idbigint

    YESMUL
    4create_timedatetime

    YES
    5update_timedatetime

    YES
    6added_by_idbigint

    YES
    7upd_by_idbigint

    YES
    8is_allowedinteger
    1NO
  46. x_group_module_perm 

    Description: (Table added to enable Permission model in Ranger).This table contains mapping of group and module. Important attributes are group_id, module_id, is_allowed. 'group_id' is foreign key of 'x_group.id' and 'module_id' is foreign key of 'x_modules_master.id' column. 'is_allowed' flag denotes whether a group has access to mapped group or not.

    ORDINAL_POSITIONCOLUMN_NAMEDATA_TYPECOLUMN_SIZECOLUMN_DEFAULTIS_NULLABLECOLUMN_KEY
    1idbigint

    NOPRI
    2group_idbigint

    YESMUL
    3module_idbigint

    YESMUL
    4create_timedatetime

    YES
    5update_timedatetime

    YES
    6added_by_idbigint

    YES
    7upd_by_idbigint

    YES
    8is_allowedinteger
    1NO
  47. x_tag_def

    Description: This table contains tag def details. Important attributes are : version, name, source, is_enabled, tag_attrs_def_text.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    NO

    UNI

    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    version

    bigint

    20


    YES


    8

    name

    varchar

    255


    NO

    UNI

    9

    source

    varchar

    128


    YES


    10

    is_enabled

    tinyint

    1

    0

    NO


    11

    tag_attrs_def_text

    mediumtext



    YES


  48. x_tag

    Description: This table contains Ranger tag details. Important attributes are: version, type, owned_by, policy_options, tag_attrs_text. ‘type’ is foreign key of table ‘x_tag_def.type’.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    NO

    UNI

    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    version

    bigint

    20


    YES


    8

    type

    bigint

    20


    NO

    MUL

    9

    owned by

    smallint

    6

      0

    NO


    10

    policy_options

    varchar

    4000


    YES


    11

    tag_attrs_text

    mediumtext



    YES


  49. x_service_resource

    Description: This table contains resources details assigned under service. Important attributes are : version, service_id, resource_signature, is _enabled, service_resource_elements_text, tags_text. 'service_id' is foreign key column of 'x_service.id'. is_enabled is the value selected under ‘Active Status’.’service_resource_elements_text’ contains actual value assigned resources details in json format, this is a very important attribute. ‘tags_text’ contains tag details service in json format. ‘resource_signatire’ is saved as a hashcode of resources.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    NO

    UNI

    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    version

    bigint

    20


    YES


    8

    service_id

    bigint

    20


    NO

    MUL

    9

    resource_signature

    varchar

    128


    YES


    10

    is_enabled

    tinyint

    4

      1

    NO


    11

    service_resource_elements_text

    mediumtext



    YES


    12

    tags_text

    mediumtext



    YES


  50. x_tag_resource_map

    Description: This table contains resource mapping details under tag. Important attributes are : tag_id, res_id. ‘tag_id’ is a foreign key column of ‘x_tag.id’. ‘res_id’ is foreign key column of ‘x_service_resource.id’.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    NO

    UNI

    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    tag_id

    bigint

    20


    NO

    MUL

    8

    res_id

    varchar

    20


    NO

    MUL

  51. x_datamask_type_def

    Description: This table contains data masking type definition details assigned under ranger service. Important attributes are : def_id, item_id, name, transformer, datamask_options, rb_key_label, rb_key_description. ‘def_id’ is foreign key of column ‘x_service_def.id’.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    def_id

    bigint

    20


    NO

    MUL

    8

    item_id

    bigint

    20


    NO


    9

    name

    varchar

    1024


    NO


    10

    label

    varchar

    1024


    NO


    11

    description

    varchar

    1024


    YES


    12

    transformer

    varchar

    1024


    YES


    13

    datamask_options

    varchar

    1024


    YES


    14

    rb_key_label

    varchar

    1024


    YES


    15

    rb_key_description

    varchar

    1024


    YES


    16

    sort_order

    int

    11

      0

    YES


  52. x_policy_item_datamask


    Note: It is not used anymore. It is available to support upgrade scenarios.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    YES


    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    updated_by_id

    bigint

    20


    YES

    MUL

    6

    policy_item_id

    bigint

      20


    NO

    MUL

    7

    type

    bigint

    20


    NO


    8condition_exprvarchar1024
    YESNULL
    9value_exprvarchar1024
    YESNULL
  53. x_policy_item_rowfilter

    Note: It is not used anymore. It is available to support upgrade scenarios.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    64


    YES


    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    updated_by_id

    bigint

    20


    YES

    MUL

    6

    policy_item_id

    bigint

      20


    NO

    MUL

    7

    filter_expr

    varchar

    1024


    YES


  54. x_service_version_info

    Description: This table contains version details for service. Important attributes are: tag_version, tag_update_time, role_version, role_update_time. 'service_id' is foreign key column of 'x_service.id'. tag_version maintains version details of tag, tag_update_time maintains last updated time of tag, role_version maintains version details of role, role_update_time maintains last updated time of role

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    service_id

    bigint

    20


    NO

    MUL

    3

    policy_version

    bigint

    20


    NO


    4

    policy_update_time

    datetime



    YES


    5

    tag_version

    bigint

    20


    NO


    6

    tag_update_time

    datetime



    YES


    7

    role_version

    bigint

    20


    NO


    8

    role_update_time

    datetime



    YES


  55. x_plugin_info

    Description: This table contains plugin details of any ranger service. Important attributes are : service_name, app_type, host_name, ip_address, info. service_name contains service name details, host_name contains host name details, ip_address contains ip address of user, info contains plugin information.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    service_name

    varchar

    255


    NO

    MUL

    5

    app_type

    varchar

    128


    NO


    6

    host_name

    varchar

    255


    NO

    MUL

    7

    ip_address

    varchar

    64


    NO


    8

    info

    varchar

    1024


    NO


  56. x_policy_label


    Description: This table mainly contains label details assigned under policy. Important attribute is label_name.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES

    MUL

    4

    update_time

    datetime



    YES

    MUL

    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    updated_by_id

    bigint

    20


    YES

    MUL

    7

    label_name

    varchar

    512


    YES

    UNI

  57. x_policy_label_map

    Description: This table contains mapping of label values assigned under policy. Important attributes are : policy_id, policy_label_id. 'policy_id' is foreign key column of 'x_policy.id' and the value contains resource entries and 'policy_label_id' is foreign key column of 'x_policy_label.id'.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES

    MUL

    4

    update_time

    datetime



    YES

    MUL

    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    updated_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    YES

    MUL

    8

    policy_label_id

    bigint

    20


    YES

    MUL

  58. x_ugsync_audit_info

    Description: This table contains Ranger user sync audit information under Ranger Audit.  Important attributes are : event_time, user_name, sync_source, no_of_new_users, no_of_new_groups, no_of_modified_users, no_of_modified_group, sync_source_info, session_id.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES


    5

    upd_by_id

    bigint

    20


    YES


    6

    event_time

    datetime



    YES

    MUL

    7

    user_name

    varchar

    255


    NO

    MUL

    8

    sync_source

    varchar

    128


    NO

    MUL

    9

    no_of_new_users

    bigint

    20


    NO


    10

    no_of_new_groups

    bigint

    20


    NO


    11

    no_of_modified_users

    bigint

    20


    NO


    12

    no_of_modified_groups

    bigint

    20


    NO


    13

    sync_source_info

    mediumtext



    NO


    14

    session_id

    varchar

    255


    YES


  59. x_policy_ref_resource

    Description: This table contains mapping of unique resource ids  assigned under policy. Important attributes are : policy_id, resource_id, resource_name. policy_id is foreign key column of 'x_policy.id', resource_id is foreign key column of x_resource_def.id' and resource_name is the name of the resource details assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    updated_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    resource_def_id

    bigint

    20


    NO

    MUL

    9

     resource_name

    varchar

    4000


    YES


  60. x_policy_ref_access_type

    Description: This table contains access type information assigned under policy. Important attributes are : policy_id, access_def_id, access_type_name. policy_id is foreign key column of 'x_policy.id', access_def_id is foreign key column of ‘x_access_type_def.id' and access_type_name permission details assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    updated_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    access_def_id

    bigint

    20


    NO

    MUL

    9

    access_type_name

    varchar

    4000


    YES


  61. x_policy_ref_condition

    Description: This table contains policy condition details values assigned under policy. Important attributes are : policy_id, condition_def_id, condition_type_name. policy_id is foreign key column of 'x_policy.id', condition_def_id is foreign key column of x_policy_condition_def.id' and condition_type_name is name of condition assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    condition_def_id

    bigint

    20


    NO

    MUL

    9

    condition_name

    varchar

    4000


    YES


  62. x_policy_ref_datamask_type

    Description: This table contains entries of data mask conditions assigned under policy. Important attributes are : policy_id, datamask_def_id, condition_type_name. policy_id is foreign key column of 'x_policy.id', datamask_def_id is foreign key column of x_datamask_type_def.id' and datamask_type_name is name of data masking condition assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    datamask_def_id

    bigint

    20


    NO

    MUL

    9

    datamask_type_name

    varchar

    4000


    YES


  63. x_policy_ref_user

    Description: This table contains user id and name assigned under policy. Important attributes are : policy_id, user_id, user_name. policy_id is foreign key column of 'x_policy.id', user_id is foreign key column of x_user.id' and user_name is the name of the user assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    user_id

    bigint

    20


    NO

    MUL

    9

    user_name

    varchar

    4000


    YES


  64. x_policy_ref_group

    Description: This table contains group values assigned under policy. Important attributes are : policy_id, group_id, group_name. policy_id is foreign key column of 'x_policy.id', group_id is foreign key column of x_group.id' and group_name is the name of the group assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    guid

    varchar

    1024


    YES


    3

    create_time

    datetime



    YES


    4

    update_time

    datetime



    YES


    5

    added_by_id

    bigint

    20


    YES

    MUL

    6

    upd_by_id

    bigint

    20


    YES

    MUL

    7

    policy_id

    bigint

    20


    NO

    MUL

    8

    group_id

    bigint

    20


    NO

    MUL

    9

    group_name

    varchar

    4000


    YES


  65. x_security_zone_ref_resource

    Description: This table contains entries of resource details assigned under Ranger security zone. Important attributes are : zone_id, resource_def, resource_name. 'zone_id' is foreign key column of 'x_security_zone.id', 'resource_def_id' is foreign key column of 'x_resource_def.id' and the resource_name contains the name of the resource.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    zone_id

    bigint

    20


    NO

    MUL

    7

    resource_def_id

    bigint

    20


    NO

    MUL

    8

    resource_name

    varchar

    255


    YES


  66. x_policy_change_log

    Description: This table contains entries of resources values assigned under policy. Important attributes are : resource_id, value. 'resource_id' is foreign key column of 'x_policy_resource.id' and value contains resource entries.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    service_id

    bigint

    20


    NO

    MUL

    4

    chnage_type

    int

    11


    NO


    5

    policy_version

    bigint

    20

    0

    NO

    MUL

    6

    service_type

    varchar

    256


    YES


    7

    policy_type

    int

    11


    YES


    8

    zone_name

    varchar

    256


    YES


    9

    policy_id

    bigint

    20


    YES


  67. x_role

    Description: This table contains Ranger Admin roles, it also contains roles synced from external sources. Important attributes of this table are version, name, description, role_options, role_text.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint



    YES

    MUL

    5

    upd_by_id

    bigint



    YES


    6

    version

    bigint

    20


    YES


    7

    name

    varchar

    255


    NO

    UNI

    8

    description

    varchar

    1024


    YES


    9

    role_options

    varchar

    4000


    YES


    10

    role_text

    mediumtext



    YES


  68. x_role_ref_user

    Description: This table contains entries of user details assigned under role. Important attributes are : role_id, user_id, user_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'user_id' is foreign key column of 'x_user.id' and the user_name contains the name of the user.  priv_type is nothing but user type which default value is 0.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id 

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20




    6

    role_id

    bigint

    20


    No

    MUL

    7

    user_id

    bigint

    20


    YES

    MUL

    8

    user_name

    varchar

    767


    YES


    9

    priv_type

    int

    10


    YES


  69. x_role_ref_group

    Description: This table contains entries of group details assigned under role. Important attributes are : role_id, group_id, group_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'group_id' is foreign key column of 'x_group.id' and the group_name contains a name of the group. priv_type is nothing but user type which default value is 0.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES

    MUL

    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    role_id

    bigint

    20


    NO

    MUL

    7

    group_id

    varchar

    20


    YES


    8

    group_name

    varchar

    767


    YES


    9

    priv_type

    int

    10


    YES


  70. x_policy_ref_role

    Description: This table contains group values assigned under policy. Important attributes are : policy_id, role_id, role_name. policy_id is foreign key column of 'x_policy.id', role_id is foreign key column of x_role.id' and role_name is the name of the role assigned under policy.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    updated_by_id

    bigint

    20


    YES

    MUL

    6

    policy_id

    bigint

    20


    NO

    MUL

    7

    role_id

    bigint

    20


    NO

    MUL

    8

     role_name

    varchar

    255


    YES


  71. x_role_ref_role

    Description: This table contains entries of role details assigned under role. Important attributes are : role_id, role_ref_id, group_name, priv_type. 'role_id' is foreign key column of 'x_role.id', 'role_ref_id' is foreign key column of 'x_role_ref_role.id' and the role_name contains a name of role. priv_type is nothing but user type which default value is 0.


    ORDINAL_POSITION


    COLUMN_NAME


    DATA_TYPE


    COLUMN_SIZE


    COLUMN_DEFAULT


    IS_NULLABLE


    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    update_time

    datetime



    YES


    4

    added_by_id

    bigint

    20


    YES

    MUL

    5

    upd_by_id

    bigint

    20


    YES

    MUL

    6

    role_ref_id

    bigint

    20


    YES

    MUL

    7

    role_id

    bigint

    20


    NO


    8

    role_name

    varchar

    255


    YES


    9

    priv_type

    int

    10


    YES


  72. x_tag_change_log

    Description: This table maintains logs for any change in tag. Important  attributes are : service_id, change_type, service_tag_version, service_resource_id, tag_id.

    ORDINAL_POSITION

    COLUMN_NAME

    DATA_TYPE

    COLUMN_SIZE

    COLUMN_DEFAULT

    IS_NULLABLE

    COLUMN_KEY

    1

    id

    bigint

    20


    NO

    PRI

    2

    create_time

    datetime



    YES


    3

    service_id

    bigint

    20


    NO

    MUL

    4

    change_type

    int

    11


    NO


    5

    service_tag_version

    bigint

    20

    0

    NO

    MUL

    6

    service_resource_id

    bigint

    20


    YES


    7

    tag_id

    bigint

    20


    YES


  73. 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_typeinteger
    0NO
    7object_idbigint

    YES
    8parent_object_idbigint

    YES
    9parent_object_class_typeinteger
    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


  • No labels