You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by ma...@apache.org on 2015/12/22 02:57:10 UTC
[4/5] incubator-ranger git commit: RANGER-794: Ranger policy engine
performance measurement
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}
+ }
+ ]