db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5763) Reference Guide should note the new casing rules for the USERNAME arguments to the NATIVE procedures
Date Wed, 16 May 2012 19:23:09 GMT

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


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.


> Reference Guide should note the new casing rules for the USERNAME arguments to the NATIVE
> ----------------------------------------------------------------------------------------------------
>                 Key: DERBY-5763
>                 URL: https://issues.apache.org/jira/browse/DERBY-5763
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            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


View raw message