Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <6783215.1191344211216.JavaMail.jira@brutus>
Date: Tue, 2 Oct 2007 09:56:51 -0700 (PDT)
From: "Daniel John Debrunner (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Resolved: (DERBY-3095) CALL
 SYSCS_UTIL.SYSCS_SET_USER_ACCESS(?, 'NOACCESS') FAILS
In-Reply-To: <7956906.1191332211584.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-3095?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel John Debrunner resolved DERBY-3095.
------------------------------------------

       Resolution: Invalid
    Fix Version/s:     (was: 10.3.1.4)
       Derby Info:   (was: [Existing Application Impact])

The only valid options for the connection_permission are: 'FULL', 'READONLY=
' or SQL NULL.

http://db.apache.org/derby/docs/dev/ref/rrefsetuseraccess.html

> CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(?, 'NOACCESS') FAILS
> ----------------------------------------------------------
>
>                 Key: DERBY-3095
>                 URL: https://issues.apache.org/jira/browse/DERBY-3095
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC, Network Client
>    Affects Versions: 10.3.1.4
>         Environment: Linux 2.6.17-13mdv #1 SMP Fri Mar 23 15:18:36 EDT 20=
07 x86_64 AMD Athlon(tm) 64 Processor 3000+ GNU/Linux
>            Reporter: EDAH-TALLY
>
> Sorry to bother you again.
> CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(?, 'NOACCESS') FAILS and here's the=
 stack trace :=20
> *************************************************************************=
*****************
> java.sql.SQLException: Droit d'acc=C3=A8s 'NOACCESS' inconnu.
>         at org.apache.derby.client.am.SQLExceptionFactory40.getSQLExcepti=
on(Unknown Source)
>         at org.apache.derby.client.am.SqlException.getSQLException(Unknow=
n Source)
>         at org.apache.derby.client.am.PreparedStatement.execute(Unknown S=
ource)
>         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(AbstractBut=
ton.java:2318)
>         at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButt=
onModel.java:387)
>         at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.j=
ava: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(B=
asicMenuItemUI.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.ja=
va:4322)
>         at java.awt.LightweightDispatcher.processMouseEvent(Container.jav=
a:3986)
>         at java.awt.LightweightDispatcher.dispatchEvent(Container.java:39=
16)
>         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(EventDispa=
tchThread.java:273)
>         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatch=
Thread.java:183)
>         at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispa=
tchThread.java:173)
>         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.ja=
va:168)
>         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.ja=
va:160)
>         at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
> Caused by: org.apache.derby.client.am.SqlException: Droit d'acc=C3=A8s 'N=
OACCESS' inconnu.
>         at org.apache.derby.client.am.Statement.completeExecute(Unknown S=
ource)
>         at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTre=
ply(Unknown Source)
>         at org.apache.derby.client.net.NetStatementReply.readExecuteCall(=
Unknown Source)
>         at org.apache.derby.client.net.StatementReply.readExecuteCall(Unk=
nown Source)
>         at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unkn=
own Source)
>         at org.apache.derby.client.am.Statement.readExecuteCall(Unknown S=
ource)
>         at org.apache.derby.client.am.PreparedStatement.flowExecute(Unkno=
wn 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 n=
ot up to date.
> Thank you for considering.

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.