You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by rm...@apache.org on 2015/12/02 01:38:37 UTC
[05/10] incubator-trafodion git commit: TRAFODION-1636 &
TRAFODION-1642
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7a085965/core/sql/regress/newregr/mvs/EXPECTEDMV500A
----------------------------------------------------------------------
diff --git a/core/sql/regress/newregr/mvs/EXPECTEDMV500A b/core/sql/regress/newregr/mvs/EXPECTEDMV500A
deleted file mode 100644
index 3897231..0000000
--- a/core/sql/regress/newregr/mvs/EXPECTEDMV500A
+++ /dev/null
@@ -1,5179 +0,0 @@
->>log;
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_874534873_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_464643344_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_782343474_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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
-
-C:/Tdm_SQL/bin/sqlci.exe
-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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_155819335_9272 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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_493443845_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_118397716_9272 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
-
-C:/Tdm_SQL/bin/sqlci.exe
-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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_972752936_9272 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;
-
---- SQL operation complete.
->>
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (10,2);
-
---- 1 row(s) inserted.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user2_1)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>--FAIL
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3);
-
-*** ERROR[4481] The user does not have INSERT 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 "INSERTRESTRICT(insertR1_user1_2)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3);
-
---- 1 row(s) inserted.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_3)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>--FAIL
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3);
-
-*** ERROR[4481] The user does not have INSERT 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 "INSERTRESTRICT(insertR1_user3_1)" -u $$SQLUSER3X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>--FAIL
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (11,3);
-
-*** ERROR[4481] The user does not have INSERT 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 "INSERTRESTRICT(insertR1_user1_4)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4);
-
---- 1 row(s) inserted.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "INSERTRESTRICT(insertR1_user1_5)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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;
-
---- SQL operation complete.
->>--FAIL
->>insert into table ( MV_TABLE c1.s1.mv10 ) values (12,4);
-
-*** ERROR[4481] The user does not have INSERT 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 "INSERTRESTRICT(insertR1_user1_7)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_397687517_9272 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
-
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_947436137_9272 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;
-
---- SQL operation complete.
->>
->>-- FAIL - since an MV is not updatable by definition.
->>update TABLE (MV_TABLE mv10) set a=1 where a=6;
-
---- 0 row(s) updated.
->>
->>-- 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
-
-C:/Tdm_SQL/bin/sqlci.exe
-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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_158488747_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_514668287_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_465591728_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_817146668_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_696163419_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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_536597159_9272 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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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)";
-C:/Tdm_SQL/bin/sqlci.exe
-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$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?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 default POS_ALLOW_NON_PK_TABLES 'ON';
-
---- SQL operation complete.
->>
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>create table t1 ( a int ) attribute all mvs allowed;
-
---- SQL operation complete.
->>grant select on t1 to $$SQLUSER2Q$$;
-
---- SQL operation complete.
->>
->>create table t10 ( a int ) attribute all mvs allowed;
-
---- SQL operation complete.
->>grant select on t10 to $$SQLUSER2Q$$;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR3_user2_1)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section wgoR3_user2_1
->>set schema c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>create view v2 as select * from c1.s1.t1;
-
---- SQL operation complete.
->>create view v22 as select * from v2;
-
---- SQL operation complete.
->>
->>grant select on v22 to $$SQLUSER3Q$$;
-
-*** WARNING[1012] No privileges were granted. You lack grant option on the specified privileges.
-
---- SQL operation completed with warnings.
->>
->>
->>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_997496299_9272 was created for the materialized view.
-
---- SQL operation completed with warnings.
->>create view v220 as select * from mv20;
-
---- SQL operation complete.
->>
->>grant select on v220 to $$SQLUSER3Q$$;
-
---- SQL operation complete.
->>
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR3_user1_2)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section wgoR3_user1_2
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>grant select on t1 to $$SQLUSER2Q$$ with grant option;
-
---- 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 "WGORESTRICT(wgoR3_user2_2)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section wgoR3_user2_2
->>set schema c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>grant select on v22 to $$SQLUSER3Q$$;
-
---- SQL operation complete.
->>grant select on v220 to $$SQLUSER3Q$$;
-
---- SQL operation complete.
->>
->>
->>drop view v22;
-
---- SQL operation complete.
->>drop view v2;
-
---- SQL operation complete.
->>
->>drop view v220;
-
---- SQL operation complete.
->>drop mv mv20;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "WGORESTRICT(wgoR3_user1_3)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section wgoR3_user1_3
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>
->>drop table t1;
-
---- SQL operation complete.
->>drop table t10;
-
---- SQL operation complete.
->>exit;
-
-End of MXCI Session
-
->>
->>exit;
-
-End of MXCI Session
-
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section column_reference_all
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_title)";
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_title
->>---------------------------------------------------------
->>-- TABLE ON TABLE
->>
->>exit;
-
-End of MXCI Session
-
->>
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user1_1)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_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 t1 ( a int not null unique, b int ) attribute all mvs allowed;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user2_1)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user2_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 c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>--FAIL
->>create table t2 ( c int references c1.s1.t1 (a) , d int ) attribute all mvs allowed;
-
-*** WARNING[1302] NO ACTION referential action for ON UPDATE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
-*** WARNING[1302] NO ACTION referential action for ON DELETE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
-*** ERROR[1184] You do not have the required privilege(s) on C1.S1.T1.A.
-
-*** ERROR[1017] You are not authorized to perform this operation.
-
---- SQL operation failed with errors.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user1_2)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user1_2
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>grant select on t1 to $$SQLUSER2Q$$;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user2_2)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user2_2
->>-- 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 c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>--FAIL
->>create table t2 ( c int references c1.s1.t1 (a) , d int ) attribute all mvs allowed;
-
-*** WARNING[1302] NO ACTION referential action for ON UPDATE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
-*** WARNING[1302] NO ACTION referential action for ON DELETE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
-*** ERROR[1184] You do not have the required privilege(s) on C1.S1.T1.A.
-
-*** ERROR[1017] You are not authorized to perform this operation.
-
---- SQL operation failed with errors.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user1_3)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user1_3
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>grant references (a, b) on t1 to $$SQLUSER2Q$$;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user2_3)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user2_3
->>-- 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 c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>create table t2 ( c int references c1.s1.t1 (a) , d int ) attribute all mvs allowed;
-
-*** WARNING[1302] NO ACTION referential action for ON UPDATE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
-*** WARNING[1302] NO ACTION referential action for ON DELETE clause behaves like RESTRICT referential action. To alter the behavior, set the appropriate value for the REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT default.
-
---- SQL operation completed with warnings.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user1_4)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user1_4
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>--FAIL
->>revoke references (a,b) on t1 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 "COLUMNREFERENCE(COLUMNREFERENCE1_user2_4)" -u $$SQLUSER2X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user2_4
->>set schema c2.s2;
-
---- SQL operation complete.
->>
->>--sql_user2
->>-----------
->>drop table t2;
-
---- SQL operation complete.
->>
->>exit;
-
-End of MXCI Session
-
->>sh sh runmxci.ksh -i "COLUMNREFERENCE(COLUMNREFERENCE1_user1_5)" -u $$SQLUSER1X$$;
-C:/Tdm_SQL/bin/sqlci.exe
-Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.5
-(c) Copyright 2003-2010 Hewlett-Packard Development Company, LP.
->>?section COLUMNREFERENCE1_user1_5
->>set schema c1.s1;
-
---- SQL operation complete.
->>
->>--sql_user1
->>-----------
->>revoke references (a,b) on t1 from $$SQ
<TRUNCATED>