[
https://issues.apache.org/jira/browse/DERBY-5329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13065415#comment-13065415
]
Kim Haase commented on DERBY-5329:
----------------------------------
Thanks for all the help!
The spec was written in 2006, and some system routines have been added since
then. What are the execute privileges for the following? I've made a few
guesses.
SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure
SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function
SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE system function (everyone? as for statistics
ones)
SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure (everyone? as for statistics
ones)
SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA system function (everyone? as for statistics
ones)
SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure (everyone? as for
statistics ones)
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure (DBO?)
SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure
SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY system procedure
SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure (everyone? as for other
statistics ones)
Thanks!
> 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
> Attachments: 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
