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


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 [EMAIL PROTECTED], 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.

Reply via email to