db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5329) Document who is allowed to run which system procedures/functions.
Date Mon, 18 Jul 2011 20:23:57 GMT

    [ 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

        

Mime
View raw message