You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <ji...@apache.org> on 2007/10/29 23:13:51 UTC
[jira] Created: (DERBY-3159) SYSCS_SET_USER_ACCESS fails if the
user name contains characters not allowed in regular identifiers.
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 fred@derby.com 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.
[jira] Resolved: (DERBY-3159) SYSCS_SET_USER_ACCESS fails if the
user name contains characters not allowed in regular identifiers.
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel John Debrunner resolved DERBY-3159.
------------------------------------------
Resolution: Fixed
Fix Version/s: 10.4.0.0
Revision 589894 in trunk fixes the issue.
> 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
> Fix For: 10.4.0.0
>
>
> 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 fred@derby.com 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.
[jira] Updated: (DERBY-3159) SYSCS_SET_USER_ACCESS fails if the
user name contains characters not allowed in regular identifiers.
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel John Debrunner updated DERBY-3159:
-----------------------------------------
Fix Version/s: 10.3.1.5
Fix merged to 10.3 branch as 596763
> 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
> Fix For: 10.3.1.5, 10.4.0.0
>
>
> 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 fred@derby.com 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.