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

Daniel John Debrunner commented on DERBY-2914:
----------------------------------------------

For SYSCS_GET_USER_ACCESS

The syntax of the function doesn't match the other system functions in the 
reference manual

The example doesn't use values, see the other functions in the reference man

For the example, the username needs to be in quotes, unless you mean that 
BRUNNER is a column from some table??

VALUES SYSCS_UTIL.SYSCS_GET_USER_ACCESS('BRUNNER')

> new stored procedures, SYSCS_UTIL.SYSCS_SET_USER_ACCESS, 
> SYSCS_UTIL.SYSCS_GET_USER_ACCESS, SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE() 
> should get documented
> ---------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2914
>                 URL: https://issues.apache.org/jira/browse/DERBY-2914
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.3.1.4, 10.4.0.0
>            Reporter: Myrna van Lunteren
>            Assignee: Laura Stewart
>         Attachments: rrefemptystmtcache.html, rrefgetuseraccess.html, 
> rrefsetuseraccess.html
>
>
> With DERBY-2772 and DERBY-2735 3 new procedures
> SYSCS_UTIL.SYSCS_SET_USER_ACCESS, SYSCS_UTIL.SYSCS_GET_USER_ACCESS and 
> SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE()
>  were created; they need to be documented in the reference manual.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to