http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/fbf4f353/ranger-tools/testdata/test_requests_hive.json
----------------------------------------------------------------------
diff --git a/ranger-tools/testdata/test_requests_hive.json
b/ranger-tools/testdata/test_requests_hive.json
new file mode 100644
index 0000000..6b07762
--- /dev/null
+++ b/ranger-tools/testdata/test_requests_hive.json
@@ -0,0 +1,257 @@
+ [
+ {"name":"'select default/tbl-0/col-2;' for hrt_1",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-0","column":"col-2"}},
+ "accessType":"select","user":"hrt_1","userGroups":[],"requestData":"use
default"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-1/col-3;' for hrt_2",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-1","column":"col-3"}},
+ "accessType":"select","user":"hrt_2","userGroups":[],"requestData":"use
default"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-2/col-4;' to hrt_3",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-2","column":"col-4"}},
+
"accessType":"select","user":"hrt_3","userGroups":["users"],"requestData":"use
default"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'select default/tbl-3/col-5;' to hrt_4",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-3","column":"col-5"}},
+ "accessType":"select","user":"hrt_4","userGroups":["users",
"group1"],"requestData":"use default"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-4/col-6;' to hrt_5",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-4","column":"col-6"}},
+ "accessType":"select","user":"hrt_5","userGroups":["users",
"group2"],"requestData":"use default"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-5/col-7;' to hrt_6",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-5","column":"col-7"}},
+ "accessType":"select","user":"hrt_6","userGroups":["users",
"group3"],"requestData":"use default"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'select default/tbl-6/col-8;' to hrt_7",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-6","column":"col-8"}},
+
"accessType":"select","user":"hrt_7","userGroups":["users"],"requestData":"use
finance"
+ },
+ "result":{"isAudited":false,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'select default/tbl-7/col-9 ' to hrt_8",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-7","column":"col-9"}},
+
"accessType":"select","user":"hrt_8","userGroups":["users"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-8/col-10' to hrt_9",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-8","column":"col-10"}},
+
"accessType":"select","user":"hrt_9","userGroups":["users"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'select default/tbl-9/col-1;' to hrt_10",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-9","column":"col-1"}},
+
"accessType":"select","user":"hrt_10","userGroups":["users"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-0/col-2;' to hrt_1",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-0","column":"col-2"}},
+
"accessType":"lock","user":"hrt_1","userGroups":["users","group1"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'lock default/tbl-1/col-3;' to hrt_2",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-1","column":"col-3"}},
+
"accessType":"lock","user":"hrt_2","userGroups":["users","group2"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'lock default/tbl-2/col-4;' to hrt_3",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-2","column":"col-4"}},
+
"accessType":"lock","user":"hrt_3","userGroups":["users","group3"],"requestData":"select
col1 from default.testtable"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-3/col-5;' to hrt_4",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-3","column":"col-5"}},
+
"accessType":"lock","user":"hrt_4","userGroups":["users"],"requestData":"select
col1 from default.table1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-4/col-6;' to hrt_5",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-4","column":"col-6"}},
+
"accessType":"lock","user":"hrt_5","userGroups":["users"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-5/col-7;' to hrt_6",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-5","column":"col-7"}},
+
"accessType":"lock","user":"hrt_6","userGroups":["users","group1"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-6/col-8;' to hrt_7",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-6","column":"col-8"}},
+
"accessType":"lock","user":"hrt_7","userGroups":["users"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'lock default/tbl-7/col-9;' to hrt_8",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-7","column":"col-9"}},
+
"accessType":"lock","user":"hrt_8","userGroups":["users","admin"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'lock default/tbl-8/col-10;' to hrt_9",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-8","column":"col-10"}},
+
"accessType":"lock","user":"hrt_9","userGroups":["users"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'lock default/tbl-9/col-1;' to hrt_20",
+ "request":{
+
"resource":{"elements":{"database":"default","table":"tbl-9","column":"col-1"}},
+
"accessType":"lock","user":"hrt_20","userGroups":["users","group1"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop table default/tbl-0;' to hrt_1",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-0"}},
+
"accessType":"drop","user":"hrt_1","userGroups":["users"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'drop table default/tbl-1;' to hrt_2",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-1"}},
+
"accessType":"drop","user":"hrt_2","userGroups":["users","admin"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":2}
+ }
+ ,
+ {"name":"'drop table default/tbl-2;' to hrt_3",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-2"}},
+
"accessType":"drop","user":"hrt_3","userGroups":["users"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop table default/tbl-3;' to hrt_4",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-3"}},
+
"accessType":"drop","user":"hrt_4","userGroups":["users","admin"],"requestData":"create
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop table default/tbl-4;' to hrt_5",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-4"}},
+
"accessType":"drop","user":"hrt_5","userGroups":["users"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop table default/tbl-5;' to hrt_6",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-5"}},
+
"accessType":"drop","user":"hrt_6","userGroups":["users","admin"],"requestData":"drop
table default.testtable1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop tabl default/tbl-6;' to hrt_7",
+ "request":{
+ "resource":{"elements":{"database":"default","table":"tbl-6"}},
+
"accessType":"drop","user":"hrt_7","userGroups":["users"],"requestData":"select
col1 from default.table1"
+ },
+ "result":{"isAudited":true,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'drop table to default/tbl-7' for hrt_8",
+ "request":{
+ "resource":{"elements":{"database":"default", "table":"tbl-7"}},
+
"accessType":"drop","user":"hrt_8","userGroups":["users"],"requestData":"show
columns in table1 from db1;"
+ },
+ "result":{"isAudited":false,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'_any access to default/tbl-0' for hrt_1",
+ "request":{
+ "resource":{"elements":{"database":"default", "table":"tbl-0"}},
+
"accessType":"","user":"hrt_1","userGroups":["users"],"requestData":"fictional
use case when request specified a lower level resource by skipping intermediate
resource"
+ },
+ "result":{"isAudited":false,"isAllowed":false,"policyId":-1}
+ }
+ ,
+ {"name":"'_any access to default' for hrt_2",
+ "request":{
+ "resource":{"elements":{"database":"default"}},
+ "accessType":"","user":"hrt_2","userGroups":["users"],"requestData":"use
db1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":3}
+ }
+ ,
+ {"name":"'_any access to default/tbl-1' for hrt_20",
+ "request":{
+ "resource":{"elements":{"database":"default", "table":"tbl-1"}},
+
"accessType":"","user":"hrt_20","userGroups":["users"],"requestData":"describe
db1.tbl1"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":3}
+ }
+ ,
+ {"name":"'_any access to default/tbl-2/col-4' for hrt_0",
+ "request":{
+ "resource":{"elements":{"database":"default", "table":"tbl-2",
"column":"col-4"}},
+
"accessType":"","user":"hrt_0","userGroups":["users"],"requestData":"fictional
case: request for any match today happens only at a higher levels"
+ },
+ "result":{"isAudited":true,"isAllowed":true,"policyId":3}
+ }
+ ]
