This document explains ranger 2.1.0 database schema information.It contains list of Tables its column details for databases supported.
x_db_version_h
Description: This table contains entry of java patches and sql patches executed after creation of core schema.
ORDINAL_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 version varchar 64 NO 3 inst_at timestamp CURRENT_TIMESTAMP NO 4 inst_by varchar 256 NO 5 updated_at timestamp CURRENT_TIMESTAMP NO 6 updated_by varchar 256 NO 7 active enum 1 Y YES 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
YES
MUL
x_portal_user(id) 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
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
YES
MUL
x_portal_user(id) 6
user_id
bigint
NO
MUL
x_portal_user(id) 7
user_role
varchar
128
YES
8 status integer 0 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 audit_type integer 0 NO 7 access_result integer 0 YES 8 access_type varchar 255 YES 9 acl_enforcer varchar 255 YES 10 agent_id varchar 255 YES 11 client_ip varchar 255 YES 12 client_type varchar 255 YES 13 policy_id bigint 0 YES x_policy(id) 14 repo_name varchar 255 YES 15 repo_type integer 0 YES 16 result_reason varchar 255 YES 17 session_id varchar 255 YES 18 event_time datetime YES MUL 19 request_user varchar 255 YES 20 action varchar 2,000 YES 21 request_data varchar 2,000 YES 22 resource_path varchar 2,000 YES 23 resource_type varchar 255 YES 24 seq_num bigint 0 YES 25 event_count bigint 1 YES 26 event_dur_ms bigint 1 YES 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
Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 asset_name varchar 1,024 NO 7 descr varchar 4,000 NO 8 act_status integer 0 NO 9 asset_type integer 0 NO 10 config mediumtext 1,67,77,215 YES 11 sup_native tinyint 0 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 login_id varchar 767 NO 7 user_id bigint YES MUL x_portal_user(id) 8 ext_sess_id varchar 512 YES 9 auth_time datetime NO 10 auth_status integer 0 NO 11 auth_type integer 0 NO 12 auth_provider integer 0 NO 13 device_type integer 0 NO 14 req_ip varchar 48 NO 15 req_ua varchar 1,024 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 store_name varchar 1,024 NO 7 descr varchar 4,000 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 group_name varchar 767 NO UNI 7 descr varchar 4,000 NO 8 status integer 0 NO 9 group_type integer 0 NO 10 cred_store_id bigint YES MUL x_cred_store(id) 11 group_src integer 0 NO 12 is_visible integer 1 NO 13 other_attributes varchar 4000 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 group_name varchar 1,024 NO 7 p_group_id bigint YES MUL x_group(id) 8 group_id bigint YES MUL x_group(id) 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 user_name varchar 767 NO UNI 7 descr varchar 4,000 NO 8 status integer 0 NO 9 cred_store_id bigint YES MUL x_cred_store(id) 10 is_visible integer 1 NO 11 other_attributes varchar 4000 YES 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
YES
MUL
x_portal_user(id) 6
group_name
varchar
740
NO
7
p_group_id
bigint
YES
MUL
x_group(id) 8
user_id
bigint
YES
MUL
x_user(id) 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 client_ip varchar 255 NO 7 agent_id varchar 255 YES 8 req_epoch bigint NO 9 last_updated datetime YES 10 repository_name varchar 1,024 YES 11 exported_json text 65,535 YES 12 http_ret_code integer 0 NO 13 cluster_name varchar 255 YES 14 zone_name varchar 255 YES 15 policy_version bigint YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 res_name varchar 4,000 YES 7 descr varchar 4,000 YES 8 res_type integer 0 NO 9 asset_id bigint NO MUL x_asset(id) 10 parent_id bigint YES MUL x_resource(id) 11 parent_path varchar 4,000 YES 12 is_encrypt integer 0 NO 13 is_recursive integer 0 NO 14 res_group varchar 1,024 YES 15 res_dbs text 65,535 YES 16 res_tables text 65,535 YES 17 res_col_fams text 65,535 YES 18 res_cols text 65,535 YES 19 res_udfs text 65,535 YES 20 res_status integer 1 NO 21 table_type integer 0 NO 22 col_type integer 0 NO 23 policy_name varchar 500 YES UNI 24 res_topologies text 65,535 YES 25 res_services text 65,535 YES 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
YES
MUL
x_portal_user(id) 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
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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 perm_group varchar 1,024 YES 7 res_id bigint YES MUL x_resource(id) 8 group_id bigint YES MUL x_group(id) 9 user_id bigint YES MUL x_user(id) 10 perm_for integer 0 NO 11 perm_type integer 0 NO 12 is_recursive integer 0 NO 13 is_wild_card tinyint 1 NO 14 grant_revoke tinyint 1 NO 15 ip_address text 65,535 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 5 upd_by_id bigint YES MUL x_portal_user(id) 6 res_id bigint YES MUL x_resource(id) 7 group_id bigint YES MUL x_group(id) 8 user_id bigint YES MUL x_user(id) 9 audit_type integer 0 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 guid varchar 1,024 YES 3 create_time datetime YES MUL 4 update_time datetime YES MUL 5 added_by_id bigint YES MUL x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 version bigint YES 8 name varchar 1,024 YES 9 display_name varchar 1024 YES 10 impl_class_name varchar 1,024 YES 11 label varchar 1,024 YES 12 description varchar 1,024 YES 13 rb_key_label varchar 1,024 YES 14 rb_key_description varchar 1,024 YES 15 is_enabled tinyint 1 YES 16 def_options varchar 1024 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 guid varchar 1,024 YES 3 create_time datetime YES MUL 4 update_time datetime YES MUL 5 added_by_id bigint YES MUL x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 version bigint YES 8 type bigint YES MUL 9 name varchar 255 YES UNI 10 display_name varchar 255 YES 11 policy_version bigint YES 12 policy_update_time datetime YES 13 description varchar 1,024 YES 14 is_enabled tinyint 0 NO 15 tag_service bigint YES MUL 16 tag_version bigint 0 NO 17 tag_update_time datetime YES 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
version
bigint
20
YES
7
name
varchar
255
NO
UNI
8
jsonData
mediumtext
YES
9
description
varchar
1024
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
version
bigint
20
YES
7
state_name
varchar
255
NO
UNI
8
app_data
varchar
255
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
zone_id
bigint
20
YES
MUL
x_security_zone(id) 7
service_id
bigint
20
YES
MUL
x_service(id) 8
service_name
varchar
255
YES
MUL
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
zone_id
bigint
20
YES
MUL
x_security_zone(id) 7
tag_srvc_id
bigint
20
YES
MUL
8
tag_srvc_name
varchar
255
YES
MUL
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
zone_id
bigint
20
YES
MUL
x_security_zone(id) 7
user_id
bigint
20
YES
MUL
x_user(id) 8
user_name
varchar
255
YES
MUL
9
user_type
tinyint
3
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
zone_id
bigint
20
YES
MUL
x_security_zone(id) 7
group_id
bigint
20
YES
MUL
x_group(id) 8
group_name
varchar
255
YES
9
group_type
tinyint
3
YES
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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 guid varchar 1,024 YES 3 create_time datetime YES MUL 4 update_time datetime YES MUL 5 added_by_id bigint YES MUL x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 version bigint YES 8 service bigint NO MUL x_service(id) 9 name varchar 512 NO MUL 10 policy_type integer 0 YES 11 description varchar 1,024 YES 12 resource_signature varchar 128 YES MUL 13 is_enabled tinyint 0 NO 14 is_audit_enabled tinyint 0 NO 15 policy_options varchar 4000 YES 16 policy_priority int 0 NO 17 policy_text medium_text YES 18 zone_id bigint NO x_security_zone(id) x_service_config_def
Description :
ORDINAL_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 def_id bigint NO MUL x_service_def(id) 8 item_id bigint NO 9 name varchar 1,024 YES 10 type varchar 1,024 YES 11 sub_type varchar 1,024 YES 12 is_mandatory tinyint 0 NO 13 default_value varchar 1,024 YES 14 validation_reg_ex varchar 1,024 YES 15 validation_message varchar 1,024 YES 16 ui_hint varchar 1,024 YES 17 label varchar 1,024 YES 18 description varchar 1,024 YES 19 rb_key_label varchar 1,024 YES 20 rb_key_description varchar 1,024 YES 21 rb_key_validation_message varchar 1,024 YES 22 sort_order int 0 YES 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
YES
MUL
x_portal_user(id) 7
def_id
bigint
NO
MUL
x_service_def(id) 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
x_resource_def(id) 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
int
0
YES
28 datamask_options varchar 1024 YES 29 rowfilter_options varchar 1024 YES 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
YES
MUL
x_portal_user(id) 7
def_id
bigint
NO
MUL
x_service_def(id) 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
int
0
YES
13 datamask_options varchar 1024 YES 14 rowfilter_options varchar 1024 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 atd_id bigint NO MUL x_access_type_def(id) 8 implied_grant varchar 1,024 YES 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_id, item_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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
YES
MUL
x_portal_user(id) 7
def_id
bigint
NO
MUL
x_service_def(id) 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
20 sort_order int 0 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 def_id bigint NO MUL x_service_def(id) 8 item_id bigint NO 9 name varchar 1,024 YES 10 enricher varchar 1,024 YES 11 enricher_options varchar 1,024 YES 12 sort_order int 0 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 def_id bigint NO MUL x_service_def(id) 8 item_id bigint NO 9 name varchar 1,024 YES 10 default_index bigint YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 enum_def_id bigint NO MUL x_enum_def(id) 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 int 0 YES 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
YES
MUL
x_portal_user(id) 7
service
bigint
NO
MUL
8
config_key
varchar
1,024
YES
9
config_value
varchar
4,000
YES
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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 policy_id bigint NO MUL x_policy(id) 8 res_def_id bigint NO MUL x_resource_def(id) 9 is_excludes tinyint 0 NO 10 is_recursive tinyint 0 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 resource_id bigint NO MUL x_policy_resource(id) 8 value varchar 1,024 YES 9 sort_order int 0 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 policy_id bigint NO MUL x_policy(id) 8 delegate_admin tinyint 0 NO 9 sort_order int 0 YES 10 item_type int 0 NO 11 is_enabled tinyint 1 NO 12 comments varchar 255 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 policy_item_id bigint NO MUL x_policy_item(id) 8 type bigint NO MUL x_access_type_def(id) 9 is_allowed tinyint 0 NO 10 sort_order int 0 YES 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_item_id
bigint
20
NO
MUL
x_policy_item(id) 8 type bigint NO MUL x_policy_condition_def(id) 9 value varchar 1,024 YES 10 sort_order int 0 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 policy_item_id bigint NO MUL x_policy_item(id) 8 user_id bigint YES MUL x_user(id) 9 sort_order int 0 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign 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 x_portal_user(id) 6 upd_by_id bigint YES MUL x_portal_user(id) 7 policy_item_id bigint NO MUL x_policy_item(id) 8 group_id bigint YES MUL x_group(id) 9 sort_order int 0 YES x_data_hist
Description: This table contains history of create, update and delete of objects service-defs, services and policies.
ORDINAL_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 create_time datetime YES 3 update_time datetime YES 4 obj_guid varchar 1,024 NO 5 obj_class_type integer NO 6 obj_id bigint NO MUL 7 obj_name varchar 1,024 NO 8 version bigint YES 9 action varchar 512 NO 10 from_time datetime NO 11 to_time datetime YES 12 content text 65,535 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 create_time datetime YES 3 update_time datetime YES 4 added_by_id bigint YES x_portal_user(id) 5 upd_by_id bigint YES x_portal_user(id) 6 module varchar 1,024 NO 7 url varchar 1,024 YES 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 user_id bigint YES MUL x_portal_user(id) 3 module_id bigint YES MUL x_modules_master(id) 4 create_time datetime YES 5 update_time datetime YES 6 added_by_id bigint YES x_portal_user(id) 7 upd_by_id bigint YES x_portal_user(id) 8 is_allowed integer 1 NO 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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY Foreign Key 1 id bigint NO PRI 2 group_id bigint YES MUL x_group(id) 3 module_id bigint YES MUL x_modules_master(id) 4 create_time datetime YES 5 update_time datetime YES 6 added_by_id bigint YES x_portal_user(id) 7 upd_by_id bigint YES x_portal_user(id) 8 is_allowed integer 1 NO 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 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
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 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
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
version
bigint
20
YES
8
service_id
bigint
20
NO
MUL
x_service(id) 9
resource_signature
varchar
128
YES
UNI 10
is_enabled
tinyint
1
1
NO
11
service_resource_elements_text
mediumtext
YES
12
tags_text
mediumtext
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
tag_id
bigint
20
NO
MUL
8
res_id
bigint
20
NO
MUL
x_service_resource(id) 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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
def_id
bigint
20
NO
MUL
x_service_def(id) 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
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
policy_item_id
bigint
20
NO
MUL
x_policy_item(id) 7
type
bigint
20
NO
MUL x_datamask_type_def(id) 8 condition_expr varchar 1024 YES 9 value_expr varchar 1024 YES 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
policy_item_id
bigint
20
NO
MUL
x_policy_item(id) 7
filter_expr
varchar
1024
YES
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
Foreign Key 1
id
bigint
20
NO
PRI
2
service_id
bigint
20
NO
MUL
x_service(id) 3
policy_version
bigint
20
0 NO
4
policy_update_time
datetime
YES
5
tag_version
bigint
20
0 NO
6
tag_update_time
datetime
YES
7
role_version
bigint
20
0 NO
8
role_update_time
datetime
YES
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
Foreign 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
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
label_name
varchar
512
YES
UNI
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
YES
MUL
x_policy(id) 8
policy_label_id
bigint
20
YES
MUL
x_policy_label(id) 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
Foreign Key 1
id
bigint
20
NO
PRI
2
create_time
datetime
YES
3
update_time
datetime
YES
4
added_by_id
bigint
20
YES
x_portal_user(id) 5
upd_by_id
bigint
20
YES
x_portal_user(id) 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
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
resource_def_id
bigint
20
NO
MUL
x_resource_def(id) 9
resource_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
access_def_id
bigint
20
NO
MUL
x_access_type_def(id) 9
access_type_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
condition_def_id
bigint
20
NO
MUL
x_policy_condition_def(id) 9
condition_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
datamask_def_id
bigint
20
NO
MUL
x_datamask_type_def(id) 9
datamask_type_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
user_id
bigint
20
NO
MUL
x_user(id) 9
user_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 6
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 7
policy_id
bigint
20
NO
MUL
x_policy(id) 8
group_id
bigint
20
NO
MUL
x_group(id) 9
group_name
varchar
4000
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
zone_id
bigint
20
NO
MUL
x_security_zone(id) 7
resource_def_id
bigint
20
NO
MUL
x_resource_def(id) 8
resource_name
varchar
255
YES
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
Foreign Key 1
id
bigint
20
NO
PRI
2
create_time
datetime
YES
3
service_id
bigint
20
NO
MUL
x_service(id) 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
x_policy(id) 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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
YES
x_portal_user(id) 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
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
x_portal_user(id) 6
role_id
bigint
20
No
MUL
x_role(id) 7
user_id
bigint
20
YES
MUL
x_user(id) 8
user_name
varchar
767
YES
9
priv_type
int
10
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
role_id
bigint
20
NO
MUL
x_role(id) 7
group_id
varchar
20
YES
x_group(id) 8
group_name
varchar
767
YES
9
priv_type
int
10
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
policy_id
bigint
20
NO
MUL
x_policy(id) 7
role_id
bigint
20
NO
MUL
x_role(id) 8
role_name
varchar
255
YES
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
Foreign 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
x_portal_user(id) 5
upd_by_id
bigint
20
YES
MUL
x_portal_user(id) 6
role_ref_id
bigint
20
YES
MUL
x_role(id) 7
role_id
bigint
20
NO
8
role_name
varchar
255
YES
9
priv_type
int
10
YES
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
Foreign Key 1
id
bigint
20
NO
PRI
2
create_time
datetime
YES
3
service_id
bigint
20
NO
MUL
x_service(id) 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
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_POSITION COLUMN_NAME DATA_TYPE COLUMN_SIZE COLUMN_DEFAULT IS_NULLABLE COLUMN_KEY 1 id bigint 0 NO 2 create_time datetime YES 3 update_time datetime YES 4 added_by_id bigint YES 5 upd_by_id bigint YES 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 attr_name varchar 255 YES 11 parent_object_name varchar 1,024 YES 12 object_name varchar 1,024 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