Subject | Error while granting privileges to user with '.' in name |
---|---|
Author | k_smith_000 |
Post date | 2008-03-27T19:59:52Z |
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
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
Best regards,
Kevin Smith
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
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
Best regards,
Kevin Smith