[
https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13067267#comment-13067267
]
Dag H. Wanvik commented on DERBY-5329:
--------------------------------------
> By default, all users have execute privileges on this procedure. However, in
> order for the procedure to run successfully on a given table, the user must
> be the owner of either the database or the schema in which the table resides.
The restriction is subject to the same condition, yes. That is, if <a&a
condition>, then the user must be the owner of either the database or the
schema in which the table resides.
But the first sentence complicates the exposition, I guess, since by default
there are no privileges...
Here is my attempt:
If authentication and SQL authorization are both enabled, all users have
execute privilege on the procedure, but for the operation to succeed the
current user must also own the database or schema of the table being compressed.
> Document who is allowed to run which system procedures/functions.
> -----------------------------------------------------------------
>
> Key: DERBY-5329
> URL: https://issues.apache.org/jira/browse/DERBY-5329
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.8.1.6, 10.9.0.0
>
> Attachments: DERBY-5329.diff, DERBY-5329.stat, DERBY-5329.zip,
> rrefaltertablecompress.html, rrefstorejarinstall.html
>
>
> The 5th functional spec attached to DERBY-464 contains a table describing
> which system procedures/functions can only be run by the DBO and which can be
> run by everyone. I can't find this information in our user guides. It would
> be good to copy this information into the Reference Guide topics for each of
> these procedures/functions.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
