[
https://issues.apache.org/jira/browse/DERBY-5334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase resolved DERBY-5334.
------------------------------
Resolution: Fixed
Fix Version/s: 10.9.0.0
10.8.1.6
Issue & fix info: (was: [Patch Available])
Thanks very much for the prompt review, Rick!
Committed patch DERBY-5334.diff to documentation trunk at revision 1146887.
Merged to 10.8 doc branch at revision 1146895.
> Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS
> -------------------------------------------------------------------------
>
> Key: DERBY-5334
> URL: https://issues.apache.org/jira/browse/DERBY-5334
> Project: Derby
> Issue Type: Bug
> 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-5334.diff, rrefsetuseraccess.html
>
>
> The Reference Guide topic for SYSCS_UTIL.SYSCS_SET_USER_ACCESS incorrectly
> states that the permissions are
> fullAcess
> readOnlyAccess
> You will get an error if you try to set those permissions. The actual
> permissions are
> FULLACCESS
> READONLYACCESS
> The following script shows this problem:
> ij> connect
> 'jdbc:derby:memory:db;create=true;user=admin;password=adminpassword' as
> admin_conn;
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'READONLYACCESS');
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'FULLACCESS');
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', null );
> 0 rows inserted/updated/deleted
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'readOnlyAccess');
> ERROR XCZ00: Unknown permission 'readOnlyAccess'.
> ij> call syscs_util.syscs_set_user_access ('BRUNNER', 'fullAccess');
> ERROR XCZ00: Unknown permission 'fullAccess'.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
