Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1538

Unexpected behavior on self privilege revocation

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Windows XP Pro

      Description

      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)
      ------------------------------------------------------

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                bandaram Satheesh Bandaram
                Reporter:
                yipng Yip Ng
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: