Derby
  1. Derby
  2. DERBY-1538

Unexpected behavior on self privilege revocation

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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)
      ------------------------------------------------------

        Issue Links

          Activity

          Yip Ng created issue -
          Yip Ng made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-464 [ DERBY-464 ]
          Satheesh Bandaram made changes -
          Assignee Satheesh Bandaram [ bandaram ]
          Satheesh Bandaram made changes -
          Resolution Fixed [ 1 ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Satheesh Bandaram made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Rajesh Kartha made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          Resolution Fixed [ 1 ]
          Yip Ng made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Fix Version/s 10.2.1.0 [ 11187 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12376428 ] Default workflow, editable Closed status [ 12798058 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development