[DERBY-5763] Reference Guide should note the new casing rules for the USERNAME arguments to the NATIVE procedures

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.9.1.0
• Fix Version/s: 10.9.1.0
• Component/s: Documentation
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Richard N. Hillegas
• Created: 15/May/12 17:31
• Updated: 25/May/12 13:39
• Resolved: 17/May/12 14:01

Description

The work on DERBY-5762 changed the behavior of the USERNAME arguments to the NATIVE procedures. Now those arguments are case-sensitive only if you double-quote the username string. For example, the following calls affect the same user, EDWARD:

call syscs_util.syscs_create_user( 'Edward', 'hisPassword' )
call syscs_util.syscs_create_user( 'EdWard', 'hisPassword' )

...while the following call affects a different user, EdWard:

call syscs_util.syscs_create_user( '"EdWard"', 'hisPassword' )

The rule is this: without double quotes, the USERNAME argument is uppercased. To create camel-case or lowercase users, you need to double-quote the USERNAME.

Issue Links

• relates to: DERBY-866 Derby User Management Enhancements
• relates to: DERBY-5762 Consider storing a normalized authorization id in SYS.SYSUSERS in order to make NATIVE procedures follow the same casing conventions for usernames which we use on connection urls