[DERBY-3159] SYSCS_SET_USER_ACCESS fails if the user name contains characters not allowed in regular identifiers.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.4.1.3
• Fix Version/s: 10.3.2.1, 10.4.1.3
• Component/s: SQL
• Bug behavior facts: Security
• Assignee: Daniel John Debrunner
• Reporter: Daniel John Debrunner
• Created: 29/Oct/07 22:12
• Updated: 21/Jan/11 17:50
• Resolved: 31/Oct/07 15:30

Description

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 [e-mail] then this call fails:

CALL SYSCS_UTIL.SYSCS_SET_USER_ACCESS(CURRENT_USER, 'FULLACCESS')