http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7a085965/core/sql/regress/newregr/mvs/EXPECTEDMV500A.LINUX ---------------------------------------------------------------------- diff --git a/core/sql/regress/newregr/mvs/EXPECTEDMV500A.LINUX b/core/sql/regress/newregr/mvs/EXPECTEDMV500A.LINUX deleted file mode 100644 index 56f6583..0000000 --- a/core/sql/regress/newregr/mvs/EXPECTEDMV500A.LINUX +++ /dev/null @@ -1,5789 +0,0 @@ ->>log; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section select_restrict_all ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR1_user1_1 ->>------------------------------------------------------------------------------ ->>-- checking GRANT/REVOKE SELECT privs on MVs when SELECT is executed ->> ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_721684181_2939 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR1_user2_1 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>--FAIL ->>select * from c1.s1.mv10; - -*** ERROR[4481] The user does not have SELECT privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR1_user1_2 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant select on mv10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR1_user2_2 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>select * from c1.s1.mv10; - ---- 0 row(s) selected. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR1_user1_3 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>revoke select on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR1_user2_3 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>--FAIL ->>select * from c1.s1.mv10; - -*** ERROR[4481] The user does not have SELECT privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR1_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR1_user1_4 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->> ->> ->> ->>exit; - -End of MXCI Session - ->> ->> ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_1 ->>------------------------------------------------------------------------------ ->>-- grant REVOKE select - compare view and MV ->> ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>--************************************* ->>-- FIRST A VIEW ->>--************************************* ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_2 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant select on t10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR2_user2_1 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>create view v20 as select * from c1.s1.t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_3 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>--FAIL ->>revoke select on t10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR2_user2_2 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>drop view v20; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_4 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>revoke select on t10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>--************************************* ->>-- SECOND AN MV ->>--************************************* ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_5 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant select on t10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR2_user2_3 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>create mv mv20 refresh on request initialize on refresh attribute all mvs allowed as select * from c1.s1.t10 group by a; - -*** WARNING[12112] A secondary index C2.S2.MV20_812622221_1166 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_6 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>--FAIL ->>revoke select on t10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user2_4)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR2_user2_4 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>drop mv mv20; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_7)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_7 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>revoke select on t10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR2_user1_8)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR2_user1_8 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->> ->> ->>exit; - -End of MXCI Session - ->> ->> ->> ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR3_user1_1 ->>------------------------------------------------------------------------------ ->>-- grant REVOKE select ->>-- two chains: a view on top of a view on top of a table ->>-- a view on top of an MV on top of a table ->>-- and we compare both. they must behave identicaly ->> ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR3_user1_2 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant select on t10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR3_user2_1 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>create mv mv20 refresh on request initialize on refresh attribute all mvs allowed as select * from c1.s1.t10 group by a; - -*** WARNING[12112] A secondary index C2.S2.MV20_754937449_8864 was created for the materialized view. - ---- SQL operation completed with warnings. ->>create view v20 as select * from c1.s1.t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user3_1)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section selectR3_user3_1 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>--FAIL ->>create view v30 as select * from c2.s2.mv20; - -*** ERROR[4481] The user does not have SELECT privilege on table or view C2.S2.MV20. - -*** ERROR[1079] SQL was not able to prepare the statement. - ---- SQL operation failed with errors. ->> ->> ->>--FAIL ->>create view v31 as select * from c2.s2.v20; - -*** ERROR[4481] The user does not have SELECT privilege on table or view C2.S2.V20. - -*** ERROR[1079] SQL was not able to prepare the statement. - ---- SQL operation failed with errors. ->> ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR3_user2_2 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>grant select on mv20 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->>grant select on v20 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user3_2)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section selectR3_user3_2 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>create view v30 as select * from c2.s2.mv20; - ---- SQL operation complete. ->>create view v31 as select * from c2.s2.v20; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR3_user2_3 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>--FAIL ->>revoke select on v20 from $$SQLUSER3Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>--FAIL ->>revoke select on mv20 from $$SQLUSER3Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user3_3)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section selectR3_user3_3 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>drop view v30; - ---- SQL operation complete. ->>drop view v31; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user2_4)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section selectR3_user2_4 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>revoke select on v20 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->>revoke select on mv20 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->>drop mv mv20; - ---- SQL operation complete. ->>drop view v20; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "SELECTRESTRICT(selectR3_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section selectR3_user1_3 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->> ->>exit; - -End of MXCI Session - -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section delete_restrict_all ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR1_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section deleteR1_title ->>------------------------------------------------------------------------------ ->>-- checking DELETE privs on MVs of the creator ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR1_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR1_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>insert into t10 values (1); - ---- 1 row(s) inserted. ->>insert into t10 values (2); - ---- 1 row(s) inserted. ->> ->> ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_887331793_8734 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>DELETE from mv10; - ---- 2 row(s) deleted. ->> ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section deleteR2_title ->> ->> ->>------------------------------------------------------------------------------ ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_562731794_1847 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>DELETE FROM mv10; - ---- 0 row(s) deleted. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section deleteR2_user2_1 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>--FAIL ->>DELETE FROM c1.s1.mv10; - -*** ERROR[4481] The user does not have DELETE privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_2 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant delete on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section deleteR2_user2_2 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>DELETE FROM c1.s1.mv10; - ---- 0 row(s) deleted. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_3 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>revoke DELETE on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section deleteR2_user2_3 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>--FAIL ->>DELETE FROM c1.s1.mv10; - -*** ERROR[4481] The user does not have DELETE privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user3_1)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section deleteR2_user3_1 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>--FAIL ->>DELETE FROM c1.s1.mv10; - -*** ERROR[4481] The user does not have DELETE privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_4 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>grant DELETE on mv10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user2_4)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section deleteR2_user2_4 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>grant DELETE on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user3_2)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section deleteR2_user3_2 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>DELETE FROM c1.s1.mv10; - ---- 0 row(s) deleted. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_5 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>--FAIL ->>revoke DELETE on mv10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user2_5)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section deleteR2_user2_5 ->> ->>--sql_user2 ->>----------- ->>set schema c2.s2; - ---- SQL operation complete. ->>revoke DELETE on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_6 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>revoke DELETE on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user3_3)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section deleteR2_user3_3 ->> ->>--sql_user3 ->>----------- ->>set schema c3.s3; - ---- SQL operation complete. ->>--FAIL ->>DELETE FROM c1.s1.mv10; - -*** ERROR[4481] The user does not have DELETE privilege on table or view C1.S1.MV10. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR2_user1_7)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR2_user1_7 ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR3_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section deleteR3_title ->> ->> ->>------------------------------------------------------------------------------ ->>-- view on top of MVs are not updatable and cannot be deleted from ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "DELETERESTRICT(deleteR3_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section deleteR3_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>set schema c1.s1; - ---- SQL operation complete. ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_578125372_3128 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>create view v10 as select * from t10; - ---- SQL operation complete. ->>create view v11 as select * from mv10; - ---- SQL operation complete. ->> ->>--FAIL ->>DELETE FROM v10; - ---- 0 row(s) deleted. ->> ->>--FAIL ->>DELETE FROM v11; - -*** ERROR[4028] Table or view C1.S1.V11 is not updatable. - -*** ERROR[8822] The statement was not prepared. - ->> ->>drop view v10; - ---- SQL operation complete. ->>drop view v11; - ---- SQL operation complete. ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->> ->> ->> ->> ->> ->> ->> ->>exit; - -End of MXCI Session - ->> ->>exit; - -End of MXCI Session - -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section insert_restrict_all ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section insertR1_title ->> ->>------------------------------------------------------------------------------ ->>-- checking INSERT privs on MVs ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->> ->>-- first through initializing. for that we need insert privs ->> ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_368781146_1657 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>-- no through explicite insert ->> ->>--FAIL ->>insert into mv10 values (1); - -*** ERROR[12074] A materialized view cannot be updated directly. - -*** ERROR[8822] The statement was not prepared. - ->> ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->> ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (10,2); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (10,2); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section insertR1_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>--FAIL ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant insert on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section insertR1_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke insert on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section insertR1_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>--FAIL ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user3_1)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section insertR1_user3_1 ->>set schema c3.s3; - ---- SQL operation complete. ->> ->>--sql_user3 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>--FAIL ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant insert on mv10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_4)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section insertR1_user2_4 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant insert on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user3_2)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section insertR1_user3_2 ->>set schema c3.s3; - ---- SQL operation complete. ->> ->>--sql_user3 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke insert on mv10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_5)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section insertR1_user2_5 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke insert on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke insert on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user3_3)" -u $$SQLUSER3X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER3 - ->>?section insertR1_user3_3 ->>set schema c3.s3; - ---- SQL operation complete. ->> ->>--sql_user3 ->>----------- ->>-- On Linux/NSK you cannot set parserflags unless you are super, On NT this ->>-- statement succeeds ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->>--FAIL ->>insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4); - -*** ERROR[15001] A syntax error occurred at or before: -insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4); - ^ (42 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_7)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR1_user1_7 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR2_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section insertR2_title ->> ->>------------------------------------------------------------------------------ ->>-- view on top of MVs are not updatable and cannot be inserted into ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR2_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section insertR2_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_645249378_8734 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>create view v10 as select * from t10; - ---- SQL operation complete. ->>create view v11 as select * from mv10; - ---- SQL operation complete. ->> ->>--PASS ->>insert into v10 values (1); - ---- 1 row(s) inserted. ->> ->>--FAIL ->>insert into v11 values (1,1); - -*** ERROR[4027] Table or view C1.S1.V11 does not permit insertions. - -*** ERROR[8822] The statement was not prepared. - ->> ->> ->>drop view v10; - ---- SQL operation complete. ->>drop view v11; - ---- SQL operation complete. ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->> ->> ->> ->> ->> ->>exit; - -End of MXCI Session - ->> ->>exit; - -End of MXCI Session - -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section update_restrict_all ->>sh sh runmxci.ksh -i "UPDATERESTRICT(updateR1_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section updateR1_user1_1 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>------------------------------------------------------------------------------ ->>-- checking update for owner - there should be none. ->>-- also checking Grant update and grant ALL options on MVs ->>-- no UPDATE grant option for MVs ->> ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->> ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_449458992_4749 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>-- FAIL - blocked by the binder ->>update mv10 set a=1 where a=6; - -*** ERROR[12074] A materialized view cannot be updated directly. - -*** ERROR[8822] The statement was not prepared. - ->> ->>-- lets try with special syntax ->>set PARSERFLAGS 3; - -*** ERROR[1017] You are not authorized to perform this operation. - -*** ERROR[8822] The statement was not prepared. - ->> ->>-- FAIL - since an MV is not updatable by definition. ->>update TABLE (MV_TABLE mv10) set a=1 where a=6; - -*** ERROR[15001] A syntax error occurred at or before: -update TABLE (MV_TABLE mv10) set a=1 where a=6; - ^ (28 characters from start of SQL statement) - -*** ERROR[8822] The statement was not prepared. - ->> ->>-- FAIL ->>grant update on mv10 to $$SQLUSER2Q$$; - -*** ERROR[12028] Grant update is not allowed for materialized views. - ---- SQL operation failed with errors. ->> ->>-- FAIL ->>grant update on mv10 to $$SQLUSER2Q$$ with grant option; - -*** ERROR[12028] Grant update is not allowed for materialized views. - ---- SQL operation failed with errors. ->> ->>-- FAIL ->>grant all on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>-- FAIL ->>grant all on mv10 to $$SQLUSER2Q$$ with grant option; - ---- SQL operation complete. ->> ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->>exit; - -End of MXCI Session - ->> ->>exit; - -End of MXCI Session - -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgo_restrict_all ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR1_title ->> ->>------------------------------------------------------------------------------ ->>-- WITH GRANT OPTION RESTRICT ->>-- if we grant and the grantee already has granted we cannot revoke. ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR1S_title ->>------------------------------------------------------------------------------ ->>-- SELECT ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_822398566_4828 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant SELECT on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1S_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- WARNING ->>grant SELECT on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant SELECT on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1S_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant SELECT on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke SELECT on mv10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1S_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke SELECT on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke select on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1S_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1S_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR1I_title ->> ->> ->>------------------------------------------------------------------------------ ->>-- INSERT ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_561464693_8113 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant INSERT on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1I_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- WARNING ->>grant INSERT on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant INSERT on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1I_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant INSERT on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke INSERT on mv10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1I_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke INSERT on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke INSERT on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1I_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1I_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR1D_title ->> ->>------------------------------------------------------------------------------ ->>-- DELETE ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_284691154_7791 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant DELETE on mv10 to $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1D_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- WARNING ->>grant DELETE on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant DELETE on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1D_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant DELETE on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke DELETE on mv10 from $$SQLUSER2Q$$; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR1D_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke DELETE on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke DELETE on mv10 from $$SQLUSER2Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR1D_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR1D_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR2_title ->> ->> ->>------------------------------------------------------------------------------ ->>-- REVOKING WGO when it is being used ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR2S_title ->> ->>------------------------------------------------------------------------------ ->>-- SELECT ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_782753678_6452 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant SELECT on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2S_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant SELECT on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke GRANT OPTION FOR SELECT on mv10 from $$SQLUSER2Q$$ ; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2S_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke SELECT on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke GRANT OPTION FOR SELECT on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2S_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->> ->>-- WARNING ->>grant SELECT on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->>select * from c1.s1.mv10; - ---- 0 row(s) selected. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke SELECT on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2S_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2S_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR2I_title ->> ->>------------------------------------------------------------------------------ ->>-- INSERT ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on refresh attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_112199374_9145 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant INSERT on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2I_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant INSERT on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke GRANT OPTION FOR INSERT on mv10 from $$SQLUSER2Q$$ ; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2I_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke INSERT on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke GRANT OPTION FOR INSERT on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2I_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- WARNING ->> ->>grant SELECT on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke INSERT on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2I_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2I_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR2D_title ->> ->>------------------------------------------------------------------------------ ->>-- DELETE ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query default POS_ALLOW_NON_PK_TABLES 'ON'; - ---- SQL operation complete. ->> ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>create table t10 ( a int ) attribute all mvs allowed; - ---- SQL operation complete. ->>create MV mv10 refresh on request initialize on create attribute all mvs allowed as select * from t10 group by a; - -*** WARNING[12112] A secondary index C1.S1.MV10_771166119_8294 was created for the materialized view. - ---- SQL operation completed with warnings. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_2)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_2 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>grant DELETE on mv10 to $$SQLUSER2Q$$ WITH GRANT OPTION; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user2_1)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2D_user2_1 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>grant DELETE on c1.s1.mv10 to $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_3)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_3 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>--FAIL ->>revoke GRANT OPTION FOR DELETE on mv10 from $$SQLUSER2Q$$ ; - -*** ERROR[1014] Privileges were not revoked. Dependent privilege descriptors still exist. - ---- SQL operation failed with errors. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user2_2)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2D_user2_2 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>revoke DELETE on c1.s1.mv10 from $$SQLUSER3Q$$; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_4)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_4 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke GRANT OPTION FOR DELETE on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user2_3)" -u $$SQLUSER2X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER2 - ->>?section wgoR2D_user2_3 ->>set schema c2.s2; - ---- SQL operation complete. ->> ->>--sql_user2 ->>----------- ->>-- WARNING ->>grant DELETE on c1.s1.mv10 to $$SQLUSER3Q$$; - -*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges. - ---- SQL operation completed with warnings. ->> ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_5)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_5 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>revoke DELETE on mv10 from $$SQLUSER2Q$$ ; - ---- SQL operation complete. ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR2D_user1_6)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR2D_user1_6 ->>set schema c1.s1; - ---- SQL operation complete. ->> ->>--sql_user1 ->>----------- ->>drop mv mv10; - ---- SQL operation complete. ->>drop table t10; - ---- SQL operation complete. ->> ->> ->> ->> ->>exit; - -End of MXCI Session - ->> ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR3_title)"; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. ->>?section wgoR3_title ->> ->>------------------------------------------------------------------------------ ->>-- ADDING WITH GRANT OPTION after a simple grant ->> ->>exit; - -End of MXCI Session - ->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR3_user1_1)" -u $$SQLUSER1X$$; -/home/rmarton/svn_ws/security_dev_int_m4/sqf/export/bin32/sqlci -Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5 -(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP. - -Database user: SQL_USER1 - ->>?section wgoR3_user1_1 ->>-- This CQD is added for creating a table with no ->>-- partition or primary key when the POS is enabled. ->>control query def
<TRUNCATED>