[
https://issues.apache.org/jira/browse/DERBY-5763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13277033#comment-13277033
]
Rick Hillegas commented on DERBY-5763:
--------------------------------------
Thanks for the patch, Kim. Looks good. A couple comments:
cdevcsecurenativeauth:
o First bullet: While you're in there, I noticed something which could be
clarified now that NATIVE authentication is turned on by storing the DBO's
credentials. The sentence beginning "Individual databases can override" would
be more accurate if we rewrote it like this:
"If an individual database holds credentials for the database owner, then the
global credentials database is only used to authenticate system-wide operations
such as engine shutdown."
o Third bullet: Similarly, I would remove this bullet altogether.
Thanks,
-Rick
> Reference Guide should note the new casing rules for the USERNAME arguments
> to the NATIVE procedures
> ----------------------------------------------------------------------------------------------------
>
> Key: DERBY-5763
> URL: https://issues.apache.org/jira/browse/DERBY-5763
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: DERBY-5763.diff, DERBY-5763.stat, DERBY-5763.zip
>
>
> 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.
--
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
