Derby
  1. Derby
  2. DERBY-3095

CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(?, null) FAILS

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: None
    • Component/s: Documentation, JDBC, SQL
    • Labels:
      None
    • Environment:
      Linux 2.6.17-13mdv #1 SMP Fri Mar 23 15:18:36 EDT 2007 x86_64 AMD Athlon(tm) 64 Processor 3000+ GNU/Linux
    • Urgency:
      Normal
    • Bug behavior facts:
      Security

      Description

      Sorry to bother you again.

      CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(?, 'NOACCESS') FAILS and here's the stack trace :

      ******************************************************************************************
      java.sql.SQLException: Droit d'accès 'NOACCESS' inconnu.
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.execute(Unknown Source)
      at com.somecom.createUser(someAPP.java:190)
      at com.somecom.grantKeys(someAPP.java:288)
      at com.somecom.showGrantKeys(someAPP.java:269)
      at com.somecom.MDIMenuClicked(someAPP.java:620)
      at com.somecom.access$000(someAPP.java:15)
      at com.somecom$5.actionPerformed(someAPP.java:564)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1216)
      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1257)
      at java.awt.Component.processMouseEvent(Component.java:6038)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
      at java.awt.Component.processEvent(Component.java:5803)
      at java.awt.Container.processEvent(Container.java:2058)
      at java.awt.Component.dispatchEventImpl(Component.java:4410)
      at java.awt.Container.dispatchEventImpl(Container.java:2116)
      at java.awt.Component.dispatchEvent(Component.java:4240)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
      at java.awt.Container.dispatchEventImpl(Container.java:2102)
      at java.awt.Window.dispatchEventImpl(Window.java:2429)
      at java.awt.Component.dispatchEvent(Component.java:4240)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
      Caused by: org.apache.derby.client.am.SqlException: Droit d'accès 'NOACCESS' inconnu.
      at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
      at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown Source)
      at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown Source)
      at org.apache.derby.client.am.Statement.readExecuteCall(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeX(Unknown Source)
      ... 34 more
      *********************************************************************************************

      FULLACCESS : OK
      READONLYACCESS : OK
      NOACCESS : FAILURE

      By the way, the CONNECTION_PERMISSION parameter in the documentation is not up to date.

      Thank you for considering.

      1. 3095_00.diff
        1 kB
        EDAH-TALLY
      2. 3095_01.diff
        2 kB
        EDAH-TALLY
      3. d3095.sql
        2 kB
        John H. Embretsen
      4. REGTEST3095_00.zip
        2 kB
        EDAH-TALLY
      5. REGTEST3095_01.zip
        2 kB
        EDAH-TALLY
      6. Reproduce3095.zip
        1 kB
        EDAH-TALLY

        Issue Links

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              EDAH-TALLY
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development