[
https://issues.apache.org/jira/browse/DERBY-5334?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase closed DERBY-5334.
----------------------------
Issue was resolved several months ago, so closing.
> 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.2.2, 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
