You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2006/08/20 05:15:14 UTC
[jira] Resolved: (DERBY-1538) Unexpected behavior on self privilege
revocation
[ http://issues.apache.org/jira/browse/DERBY-1538?page=all ]
Satheesh Bandaram resolved DERBY-1538.
--------------------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
If anyone has itch or interest to port this to 10.2, I will leave it up to them.
This fix raises an error for both GRANT or REVOKE operations to or from object owners. Database owners also can't GRANT or REVOKE privileges to object owners.
> 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.1.0
> Environment: Windows XP Pro
> Reporter: Yip Ng
> Assigned To: Satheesh Bandaram
> Fix For: 10.3.0.0
>
>
> 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