db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-1538) Unexpected behavior on self privilege revocation
Date Sun, 20 Aug 2006 03:15:14 GMT
     [ 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

        

Mime
View raw message