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
