[DERBY-5334] Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.9.1.0
• Fix Version/s: 10.8.2.2, 10.9.1.0
• Component/s: Documentation
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Richard N. Hillegas
• Created: 14/Jul/11 18:58
• Updated: 17/Feb/12 15:06
• Resolved: 14/Jul/11 21:07

Description

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