[Firebird-devel] [FB-Tracker] Reopened: (CORE-1810) Usernames with '.' character

[Alexander P. (JIRA) <tr...@fi...>]

     [ http://tracker.firebirdsql.org/browse/CORE-1810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alexander Peshkov reopened CORE-1810:
-------------------------------------


Reopened for backporting

> Usernames with '.' character
> ----------------------------
>
>                 Key: CORE-1810
>                 URL: http://tracker.firebirdsql.org/browse/CORE-1810
>             Project: Firebird Core
>          Issue Type: Bug
>          Components: Engine, GSEC
>    Affects Versions: 2.0.3, 1.5.5
>         Environment: Tested both on Linux and Windows XP.
>            Reporter: Kevin Smith
>            Assignee: Alexander Peshkov
>             Fix For: 2.5 Alpha 1
>
>
> I've created Firebird user in security database. The user name
> contains '.' character for example: kevin.smith
> When I try to grant privileges to that user I've got error:
> SQL> grant select on table to kevin.smith;
> Statement failed, SQLCODE = -104
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, column 33
> -.
> When I run query against user without '.' it works fine:
> grant select on table to UserNameWithotDot;
> GSEC allows me to add kevin.smith user and ISQL allows me to log to database using that username.
> Tested on:
> ISQL Version: LI-V2.0.3.12981 Firebird 2.0
> Server version:
> Firebird/linux Intel (access method), version "LI-V2.0.3.12981
> Firebird 2.0"
> on disk structure version 11.0

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira