SYSCS_SET_USER_ACCESS fails if the user name contains characters not allowed in 
regular identifiers. 
-----------------------------------------------------------------------------------------------------

                 Key: DERBY-3159
                 URL: https://issues.apache.org/jira/browse/DERBY-3159
             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


The procedure uses the passed in user name correctly as a normalized name but 
incorrectly validates it as though it was a SQL identifier.

E.g. if the CURRENT_USER is [EMAIL PROTECTED] then this call fails:

CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(CURRENT_USER, 'FULLACCESS')

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