[ http://issues.apache.org/jira/browse/DERBY-1538?page=comments#action_12422240 ] Mamta A. Satoor commented on DERBY-1538: ----------------------------------------
Welcome to Derby, Yip. As for this particular JIRA entry, I am not sure what SQL specification says about revoking privileges from self. But I do know that, currently in Derby, if a user in general tries to revoke a permission from another user that was never granted, the revoke is a no-op and returns back silently, just like what it did for your specific example. So, what you are seeing might be expected behavior which is not mentioned in the Grant/Revoke spec. Satheesh might now the specifics. > Unexpected behavior on self privilege revocation > ------------------------------------------------ > > Key: DERBY-1538 > URL: http://issues.apache.org/jira/browse/DERBY-1538 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.2.0.0 > Environment: Windows XP Pro > Reporter: Yip Ng > > When revoking the owner's own privilege against the table he have created, > Derby executes the revocation successfully > but the owner is able to select from the table later as if though the REVOKE > statement has no effect. More importantly, I was expecting a SQLException > with the appropriate SQLSTATE to be thrown when the owner attempts to revoke > privilege from himself. i.e.: > ij> connect 'jdbc:derby:authtest' user 'yip' as conn1; > ij> create table t1 (c1 int); > 0 rows inserted/updated/deleted > ij> insert into t1 values 1,2,3; > 3 rows inserted/updated/deleted > ij> revoke select on t1 from yip; > 0 rows inserted/updated/deleted > ij> select * from t1; > C1 > ----------- > 1 > 2 > 3 > 3 rows selected > Here is the sysinfo: > > ------------------ Java Information ------------------ > Java Version: 1.4.2_12 > Java Vendor: Sun Microsystems Inc. > Java home: C:\jdk142\jre > Java classpath: derby.jar;derbytools.jar;. > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user name: yip > Java user home: C:\Documents and Settings\Administrator > Java user dir: C:\derby\trunk\jars\sane > java.specification.name: Java Platform API Specification > java.specification.version: 1.4 > --------- Derby Information -------- > JRE - JDBC: J2SE 1.4.2 - JDBC 3.0 > [C:\derby\trunk\jars\sane\derby.jar] 10.2.0.4 alpha - (423353) > [C:\derby\trunk\jars\sane\derbytools.jar] 10.2.0.4 alpha - (423353) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > Current Locale : [English/United States [en_US]] > Found support for locale: [de_DE] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [es] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [fr] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [it] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [ja_JP] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [ko_KR] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [pt_BR] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [zh_CN] > version: 10.2.0.4 alpha - (423353) > Found support for locale: [zh_TW] > version: 10.2.0.4 alpha - (423353) > ------------------------------------------------------ -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
