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:09 UTC
[3/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_servicepolicies_hive.json
----------------------------------------------------------------------
diff --git a/ranger-tools/testdata/test_servicepolicies_hive.json b/ranger-tools/testdata/test_servicepolicies_hive.json
new file mode 100644
index 0000000..3561f65
--- /dev/null
+++ b/ranger-tools/testdata/test_servicepolicies_hive.json
@@ -0,0 +1,252899 @@
+{
+ "serviceName": "cl1_hive",
+ "serviceId": 2,
+ "policies": [
+ {
+ "service": "cl1_hive",
+ "name": "cl1_hive-1-20151212014502",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "*"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "*"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "*"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ },
+ {
+ "type": "lock",
+ "isAllowed": true
+ },
+ {
+ "type": "all",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "ambari-qa"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": true,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [],
+ "allowExceptions": [],
+ "denyExceptions": [],
+ "id": 2,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "cl1_hive-2-20151212014503",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "*"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "udf": {
+ "values": [
+ "*"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ },
+ {
+ "type": "lock",
+ "isAllowed": true
+ },
+ {
+ "type": "all",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "ambari-qa"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": true,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [],
+ "allowExceptions": [],
+ "denyExceptions": [],
+ "id": 3,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-1",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?0",
+ "tbl-1-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 5,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-2",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-3"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?1",
+ "tbl-2-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 6,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-3",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-4"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?2",
+ "tbl-3-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 7,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-4",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-5"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?3",
+ "tbl-4-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 8,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-5",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-6"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?4",
+ "tbl-5-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 9,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-6",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-7"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?5",
+ "tbl-6-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 10,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-7",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-8"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?6",
+ "tbl-7-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 11,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-8",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-9"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?7",
+ "tbl-8-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 12,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-9",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-10"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?8",
+ "tbl-9-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 13,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-10",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-1"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?9",
+ "tbl-10-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 14,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-11",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?0",
+ "tbl-11-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 15,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-12",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-3"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?1",
+ "tbl-12-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 16,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-13",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-4"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?2",
+ "tbl-13-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 17,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-14",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-5"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?3",
+ "tbl-14-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 18,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-15",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-6"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?4",
+ "tbl-15-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 19,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-16",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-7"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?5",
+ "tbl-16-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 20,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-17",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-8"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?6",
+ "tbl-17-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 21,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-18",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-9"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?7",
+ "tbl-18-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 22,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-19",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-10"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?8",
+ "tbl-19-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 23,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-20",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-1"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?9",
+ "tbl-20-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 24,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-21",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?0",
+ "tbl-21-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 25,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-22",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-3"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?1",
+ "tbl-22-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 26,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-23",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-4"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?2",
+ "tbl-23-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 27,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-24",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-5"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?3",
+ "tbl-24-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 28,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-25",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-6"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?4",
+ "tbl-25-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 29,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-26",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-7"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?5",
+ "tbl-26-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 30,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-27",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-8"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?6",
+ "tbl-27-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 31,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-28",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-9"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?7",
+ "tbl-28-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_2",
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 32,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-29",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-10"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?8",
+ "tbl-29-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_3",
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 33,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-30",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-1"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?9",
+ "tbl-30-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_4",
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_20"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "id": 34,
+ "isEnabled": true
+ },
+ {
+ "service": "cl1_hive",
+ "name": "test-policy-31",
+ "isAuditEnabled": false,
+ "resources": {
+ "database": {
+ "values": [
+ "default"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "column": {
+ "values": [
+ "col-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ },
+ "table": {
+ "values": [
+ "tbl?0",
+ "tbl-31-2"
+ ],
+ "isExcludes": false,
+ "isRecursive": false
+ }
+ },
+ "policyItems": [
+ {
+ "accesses": [
+ {
+ "type": "select",
+ "isAllowed": true
+ },
+ {
+ "type": "update",
+ "isAllowed": true
+ },
+ {
+ "type": "create",
+ "isAllowed": true
+ },
+ {
+ "type": "drop",
+ "isAllowed": true
+ },
+ {
+ "type": "alter",
+ "isAllowed": true
+ },
+ {
+ "type": "index",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_1",
+ "hrt_2",
+ "hrt_3",
+ "hrt_4"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "denyPolicyItems": [
+ {
+ "accesses": [
+ {
+ "type": "lock",
+ "isAllowed": true
+ }
+ ],
+ "users": [
+ "hrt_5",
+ "hrt_6",
+ "hrt_7",
+ "hrt_8",
+ "hrt_9"
+ ],
+ "groups": [],
+ "conditions": [],
+ "delegateAdmin": false,
+ "isEnabled": true
+ }
+ ],
+ "allowExceptions": [
+ {
+ "accesses": [
+ {
+ "type": "drop",
+ "isAllowe
<TRUNCATED>