You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ba...@apache.org on 2006/02/22 03:34:11 UTC
svn commit: r379652 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out
Author: bandaram
Date: Tue Feb 21 18:34:09 2006
New Revision: 379652
URL: http://svn.apache.org/viewcvs?rev=379652&view=rev
Log:
Submit updated grantRevoke.out master file.
Submitted by Satheesh bandaram (satheesh@sourcery.org)
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out?rev=379652&r1=379651&r2=379652&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/grantRevoke.out Tue Feb 21 18:34:09 2006
@@ -13,10 +13,10 @@
ij> grant update(i) on satheesh.tsat to bar;
0 rows inserted/updated/deleted
ij> select * from sys.systableperms;
-GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
---------------------------------------------------------------------------------------------------------------
-PUBLIC |SATHEESH |xxxxFILTERED-UUIDxxxx|y|N|N|N|N|N
-foo |SATHEESH |xxxxFILTERED-UUIDxxxx|N|y|y|y|N|N
+GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+PUBLIC |SATHEESH |xxxxFILTERED-UUIDxxxx|y|N|N|N|N|N
+foo |SATHEESH |xxxxFILTERED-UUIDxxxx|N|y|y|y|N|N
2 rows selected
ij> connect 'grantRevoke' user 'bar' as barConnection;
ij(BARCONNECTION)> -- Following revokes should fail. Only owner can revoke permissions
@@ -43,10 +43,10 @@
0 rows inserted/updated/deleted
ij(SATCONNECTION)> -- Check success by looking at systableperms directly for now
select * from sys.systableperms;
-GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
---------------------------------------------------------------------------------------------------------------
-PUBLIC |SATHEESH |xxxxFILTERED-UUIDxxxx|y|N|N|N|N|N
-foo |SATHEESH |xxxxFILTERED-UUIDxxxx|N|N|y|N|N|N
+GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+PUBLIC |SATHEESH |xxxxFILTERED-UUIDxxxx|y|N|N|N|N|N
+foo |SATHEESH |xxxxFILTERED-UUIDxxxx|N|N|y|N|N|N
2 rows selected
ij(SATCONNECTION)> revoke insert on satheesh.tsat from foo;
0 rows inserted/updated/deleted
@@ -54,8 +54,8 @@
0 rows inserted/updated/deleted
ij(SATCONNECTION)> -- Check success by looking at systableperms directly for now
select * from sys.systableperms;
-GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
---------------------------------------------------------------------------------------------------------------
+GRANTEE |GRANTOR |TABLEID |&|&|&|&|&|&
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0 rows selected
ij(SATCONNECTION)> -- Test routine permissions
CREATE FUNCTION F_ABS(P1 INT)