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

MYSQL

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

   ORDINAL_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	int		0	NO
   13	user_src	int		0	NO
   14	notes	varchar	4,000		YES

   
   
   

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

   ORDINAL_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
   8	status	int		0	NO

   
   

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

   ORDINAL_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	asset_name	varchar	1,024		NO
   7	descr	varchar	4,000		NO
   8	act_status	int		0	NO
   9	asset_type	int		0	NO
   10	config	mediumtext	1,67,77,215		YES
   11	sup_native	tinyint		0	NO

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

   ORDINAL_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	login_id	varchar	767		NO
   7	user_id	bigint			YES	MUL
   8	ext_sess_id	varchar	512		YES
   9	auth_time	datetime			NO
   10	auth_status	int		0	NO
   11	auth_type	int		0	NO
   12	auth_provider	int		0	NO
   13	device_type	int		0	NO
   14	req_ip	varchar	48		NO
   15	req_ua	varchar	1,024		YES

   
   

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

   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	store_name	varchar	1,024		NO
   7	descr	varchar	4,000		NO

   
   

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

   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

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

   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	1,024		NO
   7	descr	varchar	4,000		NO
   8	status	int		0	NO
   9	group_type	int		0	NO
   10	cred_store_id	bigint			YES	MUL
   11	group_src	int		0	NO

   
   

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

   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	1,024		NO
   7	p_group_id	bigint			YES	MUL
   8	group_id	bigint			YES	MUL

   
   

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

   ORDINAL_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_name	varchar	1,024		NO
   7	descr	varchar	4,000		NO
   8	status	int		0	NO
   9	cred_store_id	bigint			YES	MUL

   
   

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

    ORDINAL_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	1,024		NO
    7	p_group_id	bigint			YES	MUL
    8	user_id	bigint			YES	MUL

     

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

    ORDINAL_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	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	int		0	NO

     

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

    ORDINAL_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	res_name	varchar	4,000		YES
    7	descr	varchar	4,000		YES
    8	res_type	int		0	NO
    9	asset_id	bigint			NO	MUL
    10	parent_id	bigint			YES	MUL
    11	parent_path	varchar	4,000		YES
    12	is_encrypt	int		0	NO
    13	is_recursive	int		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	int		1	NO
    21	table_type	int		0	NO
    22	col_type	int		0	NO
    23	policy_name	varchar	500		YES	UNI
    24	res_topologies	text	65,535		YES
    25	res_services	text	65,535		YES

     

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

    ORDINAL_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	int		0	NO
    7	object_id	bigint			YES
    8	parent_object_id	bigint			YES
    9	parent_object_class_type	int		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

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

    ORDINAL_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	perm_group	varchar	1,024		YES
    7	res_id	bigint			YES	MUL
    8	group_id	bigint			YES	MUL
    9	user_id	bigint			YES	MUL
    10	perm_for	int		0	NO
    11	perm_type	int		0	NO
    12	is_recursive	int		0	NO
    13	is_wild_card	tinyint		1	NO
    14	grant_revoke	tinyint		1	NO
    15	ip_address	text	65,535		YES

     
    

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

    ORDINAL_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	res_id	bigint			YES	MUL
    7	group_id	bigint			YES	MUL
    8	user_id	bigint			YES	MUL
    9	audit_type	int		0	NO

     

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE	COLUMN_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		0000-00-00 00:00:00	NO
    6	updated_by	varchar	256		NO
    7	active	enum	1	Y	YES

     

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

    ORDINAL_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	audit_type	int		0	NO
    7	access_result	int		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
    14	repo_name	varchar	255		YES
    15	repo_type	int		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

     

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

    ORDINAL_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	int		0	NO
    7	object_id	bigint			YES
    8	parent_object_id	bigint			YES
    9	parent_object_class_type	int		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

ORACLE

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	FIRST_NAME	VARCHAR2	256	NULL	Y
   7	LAST_NAME	VARCHAR2	256	NULL	Y
   8	PUB_SCR_NAME	VARCHAR2	2,048	NULL	Y
   9	LOGIN_ID	VARCHAR2	767	NULL	Y
   10	PASSWORD	VARCHAR2	512		N
   11	EMAIL	VARCHAR2	512	NULL	Y
   12	STATUS	NUMBER	22	0'	N
   13	USER_SRC	NUMBER	22	0'	N
   14	NOTES	VARCHAR2	4,000	NULL	Y

    

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	USER_ID	NUMBER	22		N
   7	USER_ROLE	VARCHAR2	128	NULL	Y
   8	STATUS	NUMBER	22	0	N

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	ASSET_NAME	VARCHAR2	1,024		N
   7	DESCR	VARCHAR2	4,000	NULL	Y
   8	ACT_STATUS	NUMBER	22	0'	N
   9	ASSET_TYPE	NUMBER	22	0'	N
   10	CONFIG	CLOB	4,000		Y
   11	SUP_NATIVE	NUMBER	22	0'	N

   
   

4. x_auth_sess

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	LOGIN_ID	VARCHAR2	767		N
   7	USER_ID	NUMBER	22	NULL	Y
   8	EXT_SESS_ID	VARCHAR2	512	NULL	Y
   9	AUTH_TIME	DATE	7		N
   10	AUTH_STATUS	NUMBER	22	0'	N
   11	AUTH_TYPE	NUMBER	22	0'	N
   12	AUTH_PROVIDER	NUMBER	22	0'	N
   13	DEVICE_TYPE	NUMBER	22	0'	N
   14	REQ_IP	VARCHAR2	48		N
   15	REQ_UA	VARCHAR2	1,024	NULL	Y

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	STORE_NAME	VARCHAR2	1,024		N
   7	DESCR	VARCHAR2	4,000		N

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	GROUP_NAME	VARCHAR2	1,024		N
   7	DESCR	VARCHAR2	4,000	NULL	Y
   8	STATUS	NUMBER	22	0'	N
   9	GROUP_TYPE	NUMBER	22	0'	N
   10	CRED_STORE_ID	NUMBER	22	NULL	Y
   11	GROUP_SRC	NUMBER	22	0	N

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	GROUP_NAME	VARCHAR2	1,024		N
   7	P_GROUP_ID	NUMBER	22	NULL	Y
   8	GROUP_ID	NUMBER	22	NULL	Y

   
   

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

   ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
   1	ID	NUMBER	22		N
   2	CREATE_TIME	DATE	7	NULL	Y
   3	UPDATE_TIME	DATE	7	NULL	Y
   4	ADDED_BY_ID	NUMBER	22	NULL	Y
   5	UPD_BY_ID	NUMBER	22	NULL	Y
   6	USER_NAME	VARCHAR2	1,024		N
   7	DESCR	VARCHAR2	4,000	NULL	Y
   8	STATUS	NUMBER	22	0'	N
   9	CRED_STORE_ID	NUMBER	22	NULL	Y

   
   

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

     

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	GROUP_NAME	VARCHAR2	1,024		N
    7	P_GROUP_ID	NUMBER	22	NULL	Y
    8	USER_ID	NUMBER	22	NULL	Y

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	CLIENT_IP	VARCHAR2	255		N
    7	AGENT_ID	VARCHAR2	255	NULL	Y
    8	REQ_EPOCH	NUMBER	22		N
    9	LAST_UPDATED	DATE	7	NULL	Y
    10	REPOSITORY_NAME	VARCHAR2	1,024	NULL	Y
    11	EXPORTED_JSON	CLOB	4,000		Y
    12	HTTP_RET_CODE	NUMBER	22	0'	N

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	RES_NAME	VARCHAR2	4,000	NULL	Y
    7	DESCR	VARCHAR2	4,000	NULL	Y
    8	RES_TYPE	NUMBER	22	0'	N
    9	ASSET_ID	NUMBER	22		N
    10	PARENT_ID	NUMBER	22	NULL	Y
    11	PARENT_PATH	VARCHAR2	4,000	NULL	Y
    12	IS_ENCRYPT	NUMBER	22	0'	N
    13	IS_RECURSIVE	NUMBER	22	0'	N
    14	RES_GROUP	VARCHAR2	1,024	NULL	Y
    15	RES_DBS	CLOB	4,000		Y
    16	RES_TABLES	CLOB	4,000		Y
    17	RES_COL_FAMS	CLOB	4,000		Y
    18	RES_COLS	CLOB	4,000		Y
    19	RES_UDFS	CLOB	4,000		Y
    20	RES_STATUS	NUMBER	22	1'	N
    21	TABLE_TYPE	NUMBER	22	0'	N
    22	COL_TYPE	NUMBER	22	0'	N
    23	POLICY_NAME	VARCHAR2	500	NULL	Y
    24	RES_TOPOLOGIES	CLOB	4,000	NULL	Y
    25	RES_SERVICES	CLOB	4,000	NULL	Y

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	CLASS_TYPE	NUMBER	22	0'	N
    7	OBJECT_ID	NUMBER	22	NULL	Y
    8	PARENT_OBJECT_ID	NUMBER	22	NULL	Y
    9	PARENT_OBJECT_CLASS_TYPE	NUMBER	22	0'	N
    10	PARENT_OBJECT_NAME	VARCHAR2	1,024	NULL	Y
    11	OBJECT_NAME	VARCHAR2	1,024	NULL	Y
    12	ATTR_NAME	VARCHAR2	255	NULL	Y
    13	PREV_VAL	CLOB	4,000	NULL	Y
    14	NEW_VAL	CLOB	4,000	NULL	Y
    15	TRX_ID	VARCHAR2	1,024	NULL	Y
    16	ACTION	VARCHAR2	255	NULL	Y
    17	SESS_ID	VARCHAR2	512	NULL	Y
    18	REQ_ID	VARCHAR2	30	NULL	Y
    19	SESS_TYPE	VARCHAR2	30	NULL	Y

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	PERM_GROUP	VARCHAR2	1,024	NULL	Y
    7	RES_ID	NUMBER	22	NULL	Y
    8	GROUP_ID	NUMBER	22	NULL	Y
    9	USER_ID	NUMBER	22	NULL	Y
    10	PERM_FOR	NUMBER	22	0'	N
    11	PERM_TYPE	NUMBER	22	0'	N
    12	IS_RECURSIVE	NUMBER	22	0'	N
    13	IS_WILD_CARD	NUMBER	22	1'	N
    14	GRANT_REVOKE	NUMBER	22	1'	N
    15	IP_ADDRESS	CLOB	4,000	NULL	Y

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	RES_ID	NUMBER	22	NULL	Y
    7	GROUP_ID	NUMBER	22	NULL	Y
    8	USER_ID	NUMBER	22	NULL	Y
    9	AUDIT_TYPE	NUMBER	22	0	N

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	VERSION	VARCHAR2	64		N
    3	INST_AT	DATE	7	SYSDATE	N
    4	INST_BY	VARCHAR2	256		N
    5	UPDATED_AT	DATE	7	SYSDATE	N
    6	UPDATED_BY	VARCHAR2	256		N
    7	ACTIVE	VARCHAR2	1	Y'	Y

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7	NULL	Y
    3	UPDATE_TIME	DATE	7	NULL	Y
    4	ADDED_BY_ID	NUMBER	22	NULL	Y
    5	UPD_BY_ID	NUMBER	22	NULL	Y
    6	AUDIT_TYPE	NUMBER	22	0'	N
    7	ACCESS_RESULT	NUMBER	22	0'	Y
    8	ACCESS_TYPE	VARCHAR2	255	NULL	Y
    9	ACL_ENFORCER	VARCHAR2	255	NULL	Y
    10	AGENT_ID	VARCHAR2	255	NULL	Y
    11	CLIENT_IP	VARCHAR2	255	NULL	Y
    12	CLIENT_TYPE	VARCHAR2	255	NULL	Y
    13	POLICY_ID	NUMBER	22	0'	Y
    14	REPO_NAME	VARCHAR2	255	NULL	Y
    15	REPO_TYPE	NUMBER	22	0'	Y
    16	RESULT_REASON	VARCHAR2	255	NULL	Y
    17	SESSION_ID	VARCHAR2	255	NULL	Y
    18	EVENT_TIME	DATE	7	NULL	Y
    19	REQUEST_USER	VARCHAR2	255	NULL	Y
    20	ACTION	VARCHAR2	2,000	NULL	Y
    21	REQUEST_DATA	VARCHAR2	2,000	NULL	Y
    22	RESOURCE_PATH	VARCHAR2	2,000	NULL	Y
    23	RESOURCE_TYPE	VARCHAR2	255	NULL	Y

    
    

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

    ORDINAL_POSITION	COLUMN_NAME	DATA_TYPE	COLUMN_SIZE	COLUMN_DEFAULT	IS_NULLABLE
    1	ID	NUMBER	22		N
    2	CREATE_TIME	DATE	7		Y
    3	UPDATE_TIME	DATE	7		Y
    4	ADDED_BY_ID	NUMBER	22		Y
    5	UPD_BY_ID	NUMBER	22		Y
    6	CLASS_TYPE	NUMBER	22		N
    7	OBJECT_ID	NUMBER	22		Y
    8	PARENT_OBJECT_ID	NUMBER	22		Y
    9	PARENT_OBJECT_CLASS_TYPE	NUMBER	22		N
    10	ATTR_NAME	VARCHAR2	255		Y
    11	PARENT_OBJECT_NAME	VARCHAR2	1,024		Y
    12	OBJECT_NAME	VARCHAR2	1,024		Y
    13	PREV_VAL	CLOB	4,000		Y
    14	NEW_VAL	CLOB	4,000		Y
    15	TRX_ID	VARCHAR2	1,024		Y
    16	ACTION	VARCHAR2	255		Y
    17	SESS_ID	VARCHAR2	512		Y
    18	REQ_ID	VARCHAR2	30		Y
    19	SESS_TYPE	VARCHAR2	30		Y