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
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
