Subject SQL user management in FB 2.5
Author Tomasz Tyrakowski
Hello all,

I'm new to this group, but already have a bit of experience with IB/FB
(been playing with them since IB4). I've already benefited from the
experience of the members of this group by searching through the list
archives (btw, I'll do my best to stay a member and contribute as much
as my knowledge allows). This time it didn't work, though, so I decided
to bother you with my problem.
My question regards the new (and great) feature of FB2.5, which allows
to manipulate the security database via SQL statements (create user,
alter user, etc.).
The problem is: how can I escape user names when they happen to be SQL
reserved words? For example (that's from the real life), how to make the
statement

alter user IS grant admin role

work? It generates SQL syntax error, at least in dialect 1, which I use
out of necessity (large legacy databases).
Has anyone got stuck with a smiliar problem? Obvious solutions, like
'IS' or "IS" or `IS` don't work.
Just to prevent some (probably well earned) criticism: the problematic
users were created with gsec long ago. The names were formed based on
the initials of the users (back then it seemed a good idea).

thanks in advance
Tomasz Tyrakowski
SOL-System
Poznan, Poland

--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__