db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DERBY-3160) SYSCS_GET_USER_ACCESS incorrectly treats the passed in user name as a SQL identifier and thus can reports the wrong user information
Date Wed, 31 Oct 2007 15:59:50 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Daniel John Debrunner resolved DERBY-3160.
------------------------------------------

       Resolution: Fixed
    Fix Version/s: 10.4.0.0

Revision 590720 (trunk) fixes this.

> SYSCS_GET_USER_ACCESS incorrectly treats the passed in user name as a SQL identifier
and thus can reports the wrong user information
> ------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3160
>                 URL: https://issues.apache.org/jira/browse/DERBY-3160
>             Project: Derby
>          Issue Type: Bug
>          Components: Security, SQL
>    Affects Versions: 10.3.1.4, 10.4.0.0
>            Reporter: Daniel John Debrunner
>            Assignee: Daniel John Debrunner
>            Priority: Minor
>             Fix For: 10.4.0.0
>
>
> VALUES SYSCS_GET_USER_ACCESS(CURRENT_USER) will report the wrong user information if
the user name needs to be a delimited identifier when used in a SQL statement such as GRANT.
E.g. user fred@derby.com, 123 etc.
> Passing the user name as a VARCHAR also returns the wrong user for such user names.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message