Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 18 Jul 2011 13:33:57 +0000 (UTC)
From: "Dag H. Wanvik (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: 
 <1766128443.171.1310996037706.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1252752499.10380.1310575019823.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (DERBY-5329) Document who is allowed to run
 which system procedures/functions.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13067024#comment-13067024 ] 

Dag H. Wanvik commented on DERBY-5329:
--------------------------------------

A small comment: Sorry for my late comment on this. The sentence in section "Execute privileges":

"By default, only the database owner has execute privileges on this procedure." is not strictly accurate: Derby does not by default run with authorization enabled. Although this can perhaps be understood correctly by most users, it could possibly confuse others, so we might want to change it to "If SQL authorization is enabled (*link*), by default only the database owner has execute privileges on this procedure". What do you think?

> 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