-
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
-
Labels:None
-
Urgency:Normal
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.
- relates to
-
DERBY-866 Derby User Management Enhancements
-
- Closed
-
-
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
-
- Closed
-