http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/927b0b5a/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..83c0e9f --- /dev/null +++ b/ranger-tools/testdata/test_servicepolicies_hive.json @@ -0,0 +1,252239 @@ +{ + "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>
