[
https://issues.apache.org/jira/browse/DERBY-2264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12477837
]
Dag H. Wanvik commented on DERBY-2264:
--------------------------------------
The new error message for an unauthorized shutdown attempt is garbled for the
clients, since SYSIBM.SQLCAMESSAGE is never called (the connection is closed)
to format the message, I missed this the first time around.The new JUnit test,
DboPowersTest, never discovered this, looking only at the SQL State, but it can
be seen in output of users2.sql for the clients.
Only the message parameters appear; the message text itself is missing. I will
address this in a new patch.
> Restrict shutdown, upgrade, and encryption powers to the database owner
> -----------------------------------------------------------------------
>
> Key: DERBY-2264
> URL: https://issues.apache.org/jira/browse/DERBY-2264
> Project: Derby
> Issue Type: New Feature
> Components: Security, SQL
> Reporter: Rick Hillegas
> Assigned To: Dag H. Wanvik
> Attachments: dbaPowers.html, dbaPowers.html, DERBY-2264-1.diff,
> DERBY-2264-1.stat, DERBY-2264-2.diff, DERBY-2264-2.stat, encrypt-1b.sql,
> encrypt-2.sql, encrypt-3.sql
>
>
> This JIRA separates out the database-owner powers from the system privileges
> in the master security JIRA DERBY-2109. Restrict the following powers to the
> database owner for the moment: shutdown, upgrade, and encryption.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
