hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hubertzh...@apache.org
Subject [4/6] incubator-hawq git commit: HAWQ-1359. Add policy test for HAWQ with Ranger enabled.
Date Thu, 02 Mar 2017 01:55:08 GMT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal56_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal56_fail.ans b/src/test/feature/Ranger/ans/normal56_fail.ans
new file mode 100644
index 0000000..e77c1f0
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal56_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest56;
+SET
+drop type mytype cascade;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  type "mytype" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal56_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal56_success.ans b/src/test/feature/Ranger/ans/normal56_success.ans
new file mode 100644
index 0000000..a31a5e7
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal56_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest56;
+SET
+drop type mytype cascade;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of type mytype

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal57_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal57_fail.ans b/src/test/feature/Ranger/ans/normal57_fail.ans
new file mode 100644
index 0000000..1235d1c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal57_fail.ans
@@ -0,0 +1,14 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest57;
+SET
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+BEGIN
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+LINE 1: DECLARE mycursor CURSOR FOR SELECT * FROM a order by i;
+                                                  ^
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "a" does not exist
+LINE 1: DECLARE mycursor CURSOR FOR SELECT * FROM a order by i;
+                                                  ^
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  current transaction is aborted, commands ignored until end of transaction block
+ROLLBACK

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal57_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal57_success.ans b/src/test/feature/Ranger/ans/normal57_success.ans
new file mode 100644
index 0000000..a76f2fa
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal57_success.ans
@@ -0,0 +1,10 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest57;
+SET
+begin; DECLARE mycursor CURSOR FOR SELECT * FROM a order by i; FETCH FORWARD 2 FROM mycursor; commit;
+BEGIN
+DECLARE CURSOR
+1
+1
+COMMIT

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal58_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal58_fail.ans b/src/test/feature/Ranger/ans/normal58_fail.ans
new file mode 100644
index 0000000..bf8ab04
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal58_fail.ans
@@ -0,0 +1,12 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest58;
+SET
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+BEGIN
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "a" does not exist
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  current transaction is aborted, commands ignored until end of transaction block
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  current transaction is aborted, commands ignored until end of transaction block
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  current transaction is aborted, commands ignored until end of transaction block
+ROLLBACK

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal58_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal58_success.ans b/src/test/feature/Ranger/ans/normal58_success.ans
new file mode 100644
index 0000000..bbbdd83
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal58_success.ans
@@ -0,0 +1,11 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest58;
+SET
+BEGIN; INSERT INTO a VALUES (1); SAVEPOINT my_savepoint; INSERT INTO a VALUES (1); RELEASE SAVEPOINT my_savepoint; COMMIT;
+BEGIN
+INSERT 0 1
+SAVEPOINT
+INSERT 0 1
+RELEASE
+COMMIT

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal59_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal59_fail.ans b/src/test/feature/Ranger/ans/normal59_fail.ans
new file mode 100644
index 0000000..af4df98
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal59_fail.ans
@@ -0,0 +1,12 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest59;
+SET
+\d
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+LINE 1: select version()
+               ^
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+LINE 7:      LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnam...
+                                                          ^
+No relations found.

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal59_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal59_success.ans b/src/test/feature/Ranger/ans/normal59_success.ans
new file mode 100644
index 0000000..2cffdee
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal59_success.ans
@@ -0,0 +1,13 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest59;
+SET
+\d
+public|a|table|usertest1|append only
+public|aa|table|usertest35|append only
+public|aaa|table|usertest45|append only
+public|av|view|usertest34|none
+public|ext_t|table|usertest26|external
+public|ext_t2|table|usertest28|external
+public|foo|table|usertest20|append only
+public|myseq|sequence|usertest37|heap

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal5_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal5_success.ans b/src/test/feature/Ranger/ans/normal5_success.ans
new file mode 100644
index 0000000..658110a
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal5_success.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest5;
+SET
+drop function f4();
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  function f4() does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal60_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal60_fail.ans b/src/test/feature/Ranger/ans/normal60_fail.ans
new file mode 100644
index 0000000..63493dc
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal60_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest60;
+SET
+analyze a;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "a" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal60_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal60_success.ans b/src/test/feature/Ranger/ans/normal60_success.ans
new file mode 100644
index 0000000..d5ece26
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal60_success.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest60;
+SET
+analyze a;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  Skipping "a" --- only table or database owner can analyze it
+ANALYZE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal61_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal61_fail.ans b/src/test/feature/Ranger/ans/normal61_fail.ans
new file mode 100644
index 0000000..9e3463e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal61_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest61;
+SET
+analyze;
+ANALYZE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal61_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal61_success.ans b/src/test/feature/Ranger/ans/normal61_success.ans
new file mode 100644
index 0000000..9e3463e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal61_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest61;
+SET
+analyze;
+ANALYZE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal62_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal62_fail.ans b/src/test/feature/Ranger/ans/normal62_fail.ans
new file mode 100644
index 0000000..43fc7aa
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal62_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest62;
+SET
+vacuum aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "aa" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal62_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal62_success.ans b/src/test/feature/Ranger/ans/normal62_success.ans
new file mode 100644
index 0000000..595b0db
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal62_success.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest62;
+SET
+vacuum aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "aa" --- only table or database owner can vacuum it
+VACUUM

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal63_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal63_success.ans b/src/test/feature/Ranger/ans/normal63_success.ans
new file mode 100644
index 0000000..e4c73b9
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal63_success.ans
@@ -0,0 +1,92 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest63;
+SET
+vacuum analyze;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_packages" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_parts" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_sizing" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_sizing_profiles" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_appendonly" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_appendonly_alter_column" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_master_mirroring" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_extprotocol" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_partition" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_partition_rule" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_filespace" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_filespace_entry" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_global_sequence" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_persistent_relfile_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_relfile_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_persistent_relation_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_persistent_database_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_persistent_tablespace_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_persistent_filespace_node" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_attribute_encoding" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_compression" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_filesystem" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_foreign_data_wrapper" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_foreign_server" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_foreign_table" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_partition_encoding" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_proc_callback" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_type_encoding" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_database" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_auth_members" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_auth_time_constraint" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_authid" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_statistic" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_features" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_implementation_info" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "sql_languages" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_user_mapping" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_remote_credentials" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_type" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_attribute" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_proc" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_class" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_autovacuum" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_attrdef" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_constraint" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_inherits" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_index" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_operator" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_opclass" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_am" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_amop" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_amproc" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_language" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_largeobject" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_aggregate" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_stat_last_operation" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_stat_last_shoperation" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_rewrite" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_trigger" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_listener" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_description" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_cast" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_namespace" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_conversion" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_depend" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_tablespace" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_pltemplate" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_shdepend" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_shdescription" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_resqueue" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_configuration" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_configuration_history" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_db_interfaces" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_interfaces" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_distribution_policy" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_version_at_initdb" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_segment_configuration" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_san_configuration" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "gp_verification_history" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_window" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "pg_exttable" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "a" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "foo" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "aa" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "t" --- only table or database owner can vacuum it
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "aaa" --- only table or database owner can vacuum it
+VACUUM

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal64_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal64_fail.ans b/src/test/feature/Ranger/ans/normal64_fail.ans
new file mode 100644
index 0000000..49efa7a
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal64_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest64;
+SET
+truncate aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "aa" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal64_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal64_success.ans b/src/test/feature/Ranger/ans/normal64_success.ans
new file mode 100644
index 0000000..f72c05c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal64_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest64;
+SET
+truncate aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation aa

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal65_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal65_fail.ans b/src/test/feature/Ranger/ans/normal65_fail.ans
new file mode 100644
index 0000000..aefa01e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal65_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest65;
+SET
+alter table a rename column i to j;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  relation "a" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal65_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal65_success.ans b/src/test/feature/Ranger/ans/normal65_success.ans
new file mode 100644
index 0000000..795497e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal65_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest65;
+SET
+alter table a rename column i to j;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation a

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal66_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal66_fail.ans b/src/test/feature/Ranger/ans/normal66_fail.ans
new file mode 100644
index 0000000..597bbc7
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal66_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest66;
+SET
+drop SEQUENCE myseq;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  sequence "myseq" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal66_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal66_success.ans b/src/test/feature/Ranger/ans/normal66_success.ans
new file mode 100644
index 0000000..35b4322
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal66_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest66;
+SET
+drop SEQUENCE myseq;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation myseq

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal67_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal67_fail.ans b/src/test/feature/Ranger/ans/normal67_fail.ans
new file mode 100644
index 0000000..0d8b941
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal67_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest67;
+SET
+drop view av;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  view "av" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal67_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal67_success.ans b/src/test/feature/Ranger/ans/normal67_success.ans
new file mode 100644
index 0000000..9ac8fbc
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal67_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest67;
+SET
+drop view av;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation av

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal68_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal68_fail.ans b/src/test/feature/Ranger/ans/normal68_fail.ans
new file mode 100644
index 0000000..193b108
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal68_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest68;
+SET
+drop table aaa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  table "aaa" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal68_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal68_success.ans b/src/test/feature/Ranger/ans/normal68_success.ans
new file mode 100644
index 0000000..e72e946
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal68_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest68;
+SET
+drop table aaa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation aaa

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal69_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal69_fail.ans b/src/test/feature/Ranger/ans/normal69_fail.ans
new file mode 100644
index 0000000..0758da4
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal69_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest69;
+SET
+drop table aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  table "aa" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal69_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal69_success.ans b/src/test/feature/Ranger/ans/normal69_success.ans
new file mode 100644
index 0000000..0d230ff
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal69_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest69;
+SET
+drop table aa;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation aa

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal6_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal6_success.ans b/src/test/feature/Ranger/ans/normal6_success.ans
new file mode 100644
index 0000000..842aa47
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal6_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest6;
+SET
+drop language plpythonu;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be superuser to drop procedural language

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal70_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal70_fail.ans b/src/test/feature/Ranger/ans/normal70_fail.ans
new file mode 100644
index 0000000..35c8300
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal70_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest70;
+SET
+drop table a;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  table "a" does not exist

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal70_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal70_success.ans b/src/test/feature/Ranger/ans/normal70_success.ans
new file mode 100644
index 0000000..b6e2266
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal70_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest70;
+SET
+drop table a;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of relation a

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal71_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal71_fail.ans b/src/test/feature/Ranger/ans/normal71_fail.ans
new file mode 100644
index 0000000..d329681
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal71_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest71;
+SET
+drop schema sa CASCADE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of schema sa

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal71_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal71_success.ans b/src/test/feature/Ranger/ans/normal71_success.ans
new file mode 100644
index 0000000..d329681
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal71_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest71;
+SET
+drop schema sa CASCADE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  must be owner of schema sa

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal7_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal7_fail.ans b/src/test/feature/Ranger/ans/normal7_fail.ans
new file mode 100644
index 0000000..0911afd
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal7_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest7;
+SET
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  no schema has been selected to create in

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal7_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal7_success.ans b/src/test/feature/Ranger/ans/normal7_success.ans
new file mode 100644
index 0000000..b0b00da
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal7_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest7;
+SET
+CREATE OR REPLACE FUNCTION normalize_si(text) RETURNS text AS $$ BEGIN RETURN substring($1, 9, 2) || substring($1, 7, 2) || substring($1, 5, 2) || substring($1, 1, 4); END; $$LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal8_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal8_fail.ans b/src/test/feature/Ranger/ans/normal8_fail.ans
new file mode 100644
index 0000000..14525fa
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal8_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest8;
+SET
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  no schema has been selected to create in

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal8_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal8_success.ans b/src/test/feature/Ranger/ans/normal8_success.ans
new file mode 100644
index 0000000..edc8c5c
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal8_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest8;
+SET
+CREATE OR REPLACE FUNCTION si_lt(text, text) RETURNS boolean AS $$ BEGIN RETURN normalize_si($1) < normalize_si($2); END; $$ LANGUAGE 'plpgsql' IMMUTABLE;
+CREATE FUNCTION

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal9_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal9_fail.ans b/src/test/feature/Ranger/ans/normal9_fail.ans
new file mode 100644
index 0000000..be7add4
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal9_fail.ans
@@ -0,0 +1,7 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest9;
+SET
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  usage privilege of namespace public is required.
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  no schema has been selected to create in

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/normal9_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/normal9_success.ans b/src/test/feature/Ranger/ans/normal9_success.ans
new file mode 100644
index 0000000..c597a77
--- /dev/null
+++ b/src/test/feature/Ranger/ans/normal9_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usertest9;
+SET
+CREATE OPERATOR <# ( PROCEDURE=si_lt,LEFTARG=text, RIGHTARG=text);
+CREATE OPERATOR

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super11_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super11_fail.ans b/src/test/feature/Ranger/ans/super11_fail.ans
new file mode 100644
index 0000000..85f9b88
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super11_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper11;
+SET
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  permission denied for schema public

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super11_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super11_success.ans b/src/test/feature/Ranger/ans/super11_success.ans
new file mode 100644
index 0000000..81ebd57
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super11_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper11;
+SET
+CREATE OPERATOR CLASS sva_special_ops FOR TYPE text USING btree AS OPERATOR 1 <#, FUNCTION 1 si_same(text, text);
+CREATE OPERATOR CLASS

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super12_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super12_success.ans b/src/test/feature/Ranger/ans/super12_success.ans
new file mode 100644
index 0000000..6467f16
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super12_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper12;
+SET
+drop OPERATOR CLASS sva_special_ops USING btree;
+DROP OPERATOR CLASS

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super17_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super17_success.ans b/src/test/feature/Ranger/ans/super17_success.ans
new file mode 100644
index 0000000..c4a771f
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super17_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper17;
+SET
+CREATE RESOURCE QUEUE myqueue WITH (PARENT='pg_root', ACTIVE_STATEMENTS=20, MEMORY_LIMIT_CLUSTER=50%, CORE_LIMIT_CLUSTER=50%);   
+CREATE QUEUE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super18_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super18_success.ans b/src/test/feature/Ranger/ans/super18_success.ans
new file mode 100644
index 0000000..40ed900
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super18_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper18;
+SET
+DROP RESOURCE QUEUE myqueue;
+DROP QUEUE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super19_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super19_success.ans b/src/test/feature/Ranger/ans/super19_success.ans
new file mode 100644
index 0000000..59c0d02
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super19_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper19;
+SET
+CREATE TABLESPACE mytblspace FILESPACE dfs_system;    
+CREATE TABLESPACE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super23_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super23_success.ans b/src/test/feature/Ranger/ans/super23_success.ans
new file mode 100644
index 0000000..e3737c0
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super23_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper23;
+SET
+drop tablespace mytblspace;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  tablespace "mytblspace" is not empty: existing table.

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super24_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super24_fail.ans b/src/test/feature/Ranger/ans/super24_fail.ans
new file mode 100644
index 0000000..dc20846
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super24_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper24;
+SET
+COPY a FROM '/tmp/a.txt';
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  permission denied for relation a

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super24_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super24_success.ans b/src/test/feature/Ranger/ans/super24_success.ans
new file mode 100644
index 0000000..1f63577
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super24_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper24;
+SET
+COPY a FROM '/tmp/a.txt';
+COPY 2

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super2_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super2_fail.ans b/src/test/feature/Ranger/ans/super2_fail.ans
new file mode 100644
index 0000000..1b76d7d
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super2_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper2;
+SET
+create language plpythonu;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  permission denied for language c

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super2_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super2_success.ans b/src/test/feature/Ranger/ans/super2_success.ans
new file mode 100644
index 0000000..8668f8e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super2_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper2;
+SET
+create language plpythonu;
+CREATE LANGUAGE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super3_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super3_fail.ans b/src/test/feature/Ranger/ans/super3_fail.ans
new file mode 100644
index 0000000..6dfb35e
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super3_fail.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper3;
+SET
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: ERROR:  permission denied for schema public

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super3_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super3_success.ans b/src/test/feature/Ranger/ans/super3_success.ans
new file mode 100644
index 0000000..4a37b16
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super3_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper3;
+SET
+CREATE OR REPLACE FUNCTION f4() RETURNS TEXT AS $$ plpy.execute("select * from a order by i") $$ LANGUAGE plpythonu VOLATILE;
+CREATE FUNCTION

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super5_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super5_success.ans b/src/test/feature/Ranger/ans/super5_success.ans
new file mode 100644
index 0000000..d2bff25
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super5_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper5;
+SET
+drop function f4();
+DROP FUNCTION

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super63_fail.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super63_fail.ans b/src/test/feature/Ranger/ans/super63_fail.ans
new file mode 100644
index 0000000..07b2259
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super63_fail.ans
@@ -0,0 +1,10 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper63;
+SET
+vacuum analyze;
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "a" --- error returned: permission denied for relation(s): a
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "aa" --- error returned: permission denied for relation(s): aa
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: WARNING:  skipping "aaa" --- error returned: permission denied for relation(s): aaa
+psql:/tmp/TestHawqRanger_BasicTest.sql:4: INFO:  ANALYZE completed. Success: 85, Failure: 3 (a, aa, aaa)
+VACUUM

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super63_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super63_success.ans b/src/test/feature/Ranger/ans/super63_success.ans
new file mode 100644
index 0000000..0b43010
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super63_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper63;
+SET
+vacuum analyze;
+VACUUM

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/ans/super6_success.ans
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/ans/super6_success.ans b/src/test/feature/Ranger/ans/super6_success.ans
new file mode 100644
index 0000000..b168dda
--- /dev/null
+++ b/src/test/feature/Ranger/ans/super6_success.ans
@@ -0,0 +1,6 @@
+-- start_ignore
+-- end_ignore
+set session role=usersuper6;
+SET
+drop language plpythonu;
+DROP LANGUAGE

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/data/copydata.txt
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/data/copydata.txt b/src/test/feature/Ranger/data/copydata.txt
new file mode 100644
index 0000000..6ed281c
--- /dev/null
+++ b/src/test/feature/Ranger/data/copydata.txt
@@ -0,0 +1,2 @@
+1
+1

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/1/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/1/1.json b/src/test/feature/Ranger/policy/1/1.json
new file mode 100644
index 0000000..dccf789
--- /dev/null
+++ b/src/test/feature/Ranger/policy/1/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy1-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest1", "usersuper1"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/10/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/10/1.json b/src/test/feature/Ranger/policy/10/1.json
new file mode 100644
index 0000000..fbd564e
--- /dev/null
+++ b/src/test/feature/Ranger/policy/10/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy10-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "execute"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest10", "usersuper10"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "function": {"isExcludes": false, "isRecursive": false, "values": ["si_same"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/10/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/10/2.json b/src/test/feature/Ranger/policy/10/2.json
new file mode 100644
index 0000000..b5940c9
--- /dev/null
+++ b/src/test/feature/Ranger/policy/10/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy10-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest10", "usersuper10"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/10/3.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/10/3.json b/src/test/feature/Ranger/policy/10/3.json
new file mode 100644
index 0000000..14490da
--- /dev/null
+++ b/src/test/feature/Ranger/policy/10/3.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy10-3", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest10", "usersuper10"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "language": {"isExcludes": false, "isRecursive": false, "values": ["plpgsql"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/11/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/11/1.json b/src/test/feature/Ranger/policy/11/1.json
new file mode 100644
index 0000000..6b7117b
--- /dev/null
+++ b/src/test/feature/Ranger/policy/11/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy11-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest11", "usersuper11"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/13/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/13/1.json b/src/test/feature/Ranger/policy/13/1.json
new file mode 100644
index 0000000..245b4cc
--- /dev/null
+++ b/src/test/feature/Ranger/policy/13/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy13-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest13", "usersuper13"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/14/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/14/1.json b/src/test/feature/Ranger/policy/14/1.json
new file mode 100644
index 0000000..c81cb81
--- /dev/null
+++ b/src/test/feature/Ranger/policy/14/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy14-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest14", "usersuper14"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/15/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/15/1.json b/src/test/feature/Ranger/policy/15/1.json
new file mode 100644
index 0000000..2842a55
--- /dev/null
+++ b/src/test/feature/Ranger/policy/15/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy15-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest15", "usersuper15"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/16/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/16/1.json b/src/test/feature/Ranger/policy/16/1.json
new file mode 100644
index 0000000..025262e
--- /dev/null
+++ b/src/test/feature/Ranger/policy/16/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy16-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest16", "usersuper16"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/2/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/2/1.json b/src/test/feature/Ranger/policy/2/1.json
new file mode 100644
index 0000000..f5170f3
--- /dev/null
+++ b/src/test/feature/Ranger/policy/2/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy2-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest2", "usersuper2"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "language": {"isExcludes": false, "isRecursive": false, "values": ["c"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/20/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/20/1.json b/src/test/feature/Ranger/policy/20/1.json
new file mode 100644
index 0000000..e457b50
--- /dev/null
+++ b/src/test/feature/Ranger/policy/20/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy20-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest20", "usersuper20"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/20/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/20/2.json b/src/test/feature/Ranger/policy/20/2.json
new file mode 100644
index 0000000..0fc35e5
--- /dev/null
+++ b/src/test/feature/Ranger/policy/20/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy20-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest20", "usersuper20"]}], "resources": {"tablespace": {"isExcludes": false, "isRecursive": false, "values": ["mytblspace"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/21/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/21/1.json b/src/test/feature/Ranger/policy/21/1.json
new file mode 100644
index 0000000..49c0c89
--- /dev/null
+++ b/src/test/feature/Ranger/policy/21/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy21-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest21", "usersuper21"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/21/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/21/2.json b/src/test/feature/Ranger/policy/21/2.json
new file mode 100644
index 0000000..d5c4993
--- /dev/null
+++ b/src/test/feature/Ranger/policy/21/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy21-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "insert"}, {"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest21", "usersuper21"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["foo"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/22/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/22/1.json b/src/test/feature/Ranger/policy/22/1.json
new file mode 100644
index 0000000..1a24f96
--- /dev/null
+++ b/src/test/feature/Ranger/policy/22/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy22-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest22", "usersuper22"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/24/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/24/1.json b/src/test/feature/Ranger/policy/24/1.json
new file mode 100644
index 0000000..450778a
--- /dev/null
+++ b/src/test/feature/Ranger/policy/24/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy24-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "insert"}, {"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest24", "usersuper24"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["a"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/25/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/25/1.json b/src/test/feature/Ranger/policy/25/1.json
new file mode 100644
index 0000000..3aa805c
--- /dev/null
+++ b/src/test/feature/Ranger/policy/25/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy25-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest25", "usersuper25"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/25/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/25/2.json b/src/test/feature/Ranger/policy/25/2.json
new file mode 100644
index 0000000..16411bc
--- /dev/null
+++ b/src/test/feature/Ranger/policy/25/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy25-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest25", "usersuper25"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["a"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/26/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/26/1.json b/src/test/feature/Ranger/policy/26/1.json
new file mode 100644
index 0000000..8904593
--- /dev/null
+++ b/src/test/feature/Ranger/policy/26/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy26-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest26", "usersuper26"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/27/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/27/1.json b/src/test/feature/Ranger/policy/27/1.json
new file mode 100644
index 0000000..b2e9858
--- /dev/null
+++ b/src/test/feature/Ranger/policy/27/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy27-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest27", "usersuper27"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/27/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/27/2.json b/src/test/feature/Ranger/policy/27/2.json
new file mode 100644
index 0000000..85e2ccd
--- /dev/null
+++ b/src/test/feature/Ranger/policy/27/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy27-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest27", "usersuper27"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["ext_t"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/28/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/28/1.json b/src/test/feature/Ranger/policy/28/1.json
new file mode 100644
index 0000000..2bddfcd
--- /dev/null
+++ b/src/test/feature/Ranger/policy/28/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy28-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest28", "usersuper28"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/28/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/28/2.json b/src/test/feature/Ranger/policy/28/2.json
new file mode 100644
index 0000000..49bd614
--- /dev/null
+++ b/src/test/feature/Ranger/policy/28/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy28-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest28", "usersuper28"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["ext_t"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/29/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/29/1.json b/src/test/feature/Ranger/policy/29/1.json
new file mode 100644
index 0000000..311aa16
--- /dev/null
+++ b/src/test/feature/Ranger/policy/29/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy29-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest29", "usersuper29"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/29/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/29/2.json b/src/test/feature/Ranger/policy/29/2.json
new file mode 100644
index 0000000..4d4f632
--- /dev/null
+++ b/src/test/feature/Ranger/policy/29/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy29-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "insert"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest29", "usersuper29"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["ext_t2"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/3/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/3/1.json b/src/test/feature/Ranger/policy/3/1.json
new file mode 100644
index 0000000..60c0fd6
--- /dev/null
+++ b/src/test/feature/Ranger/policy/3/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy3-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest3", "usersuper3"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/30/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/30/1.json b/src/test/feature/Ranger/policy/30/1.json
new file mode 100644
index 0000000..362d498
--- /dev/null
+++ b/src/test/feature/Ranger/policy/30/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy30-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest30", "usersuper30"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/31/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/31/1.json b/src/test/feature/Ranger/policy/31/1.json
new file mode 100644
index 0000000..4537aa6
--- /dev/null
+++ b/src/test/feature/Ranger/policy/31/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy31-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest31", "usersuper31"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/32/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/32/1.json b/src/test/feature/Ranger/policy/32/1.json
new file mode 100644
index 0000000..b96694c
--- /dev/null
+++ b/src/test/feature/Ranger/policy/32/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy32-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "create-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest32", "usersuper32"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["*"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/33/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/33/1.json b/src/test/feature/Ranger/policy/33/1.json
new file mode 100644
index 0000000..8a6ecb9
--- /dev/null
+++ b/src/test/feature/Ranger/policy/33/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy33-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "temp"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest33", "usersuper33"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["*"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/33/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/33/2.json b/src/test/feature/Ranger/policy/33/2.json
new file mode 100644
index 0000000..492e974
--- /dev/null
+++ b/src/test/feature/Ranger/policy/33/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy33-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest33", "usersuper33"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["pg_temp_14"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/34/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/34/1.json b/src/test/feature/Ranger/policy/34/1.json
new file mode 100644
index 0000000..6cc0e4f
--- /dev/null
+++ b/src/test/feature/Ranger/policy/34/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy34-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest34", "usersuper34"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/35/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/35/1.json b/src/test/feature/Ranger/policy/35/1.json
new file mode 100644
index 0000000..d49b931
--- /dev/null
+++ b/src/test/feature/Ranger/policy/35/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy35-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest35", "usersuper35"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/35/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/35/2.json b/src/test/feature/Ranger/policy/35/2.json
new file mode 100644
index 0000000..70c04ba
--- /dev/null
+++ b/src/test/feature/Ranger/policy/35/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy35-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest35", "usersuper35"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["a"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/36/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/36/1.json b/src/test/feature/Ranger/policy/36/1.json
new file mode 100644
index 0000000..b393e95
--- /dev/null
+++ b/src/test/feature/Ranger/policy/36/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy36-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest36", "usersuper36"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["sa"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/37/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/37/1.json b/src/test/feature/Ranger/policy/37/1.json
new file mode 100644
index 0000000..1569661
--- /dev/null
+++ b/src/test/feature/Ranger/policy/37/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy37-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}, {"isAllowed": true, "type": "create"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest37", "usersuper37"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/38/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/38/1.json b/src/test/feature/Ranger/policy/38/1.json
new file mode 100644
index 0000000..fa191be
--- /dev/null
+++ b/src/test/feature/Ranger/policy/38/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy38-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest38", "usersuper38"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/38/2.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/38/2.json b/src/test/feature/Ranger/policy/38/2.json
new file mode 100644
index 0000000..1bd36ca
--- /dev/null
+++ b/src/test/feature/Ranger/policy/38/2.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy38-2", "policyItems": [{"accesses": [{"isAllowed": true, "type": "insert"}, {"isAllowed": true, "type": "select"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest38", "usersuper38"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["a"]}}, "service": "hawq", "version": 1}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/12089267/src/test/feature/Ranger/policy/39/1.json
----------------------------------------------------------------------
diff --git a/src/test/feature/Ranger/policy/39/1.json b/src/test/feature/Ranger/policy/39/1.json
new file mode 100644
index 0000000..ab9a7e0
--- /dev/null
+++ b/src/test/feature/Ranger/policy/39/1.json
@@ -0,0 +1 @@
+{"allowExceptions": [], "denyExceptions": [], "denyPolicyItems": [], "description": "no description", "isAuditEnabled": true, "isEnabled": true, "name": "policy39-1", "policyItems": [{"accesses": [{"isAllowed": true, "type": "usage-schema"}], "conditions": [], "delegateAdmin": true, "groups": null, "users": ["usertest39", "usersuper39"]}], "resources": {"database": {"isExcludes": false, "isRecursive": false, "values": ["hawq_feature_test_db"]}, "schema": {"isExcludes": false, "isRecursive": false, "values": ["public"]}, "table": {"isExcludes": false, "isRecursive": false, "values": ["*"]}}, "service": "hawq", "version": 1}
\ No newline at end of file



Mime
View raw message