Hi guys,

Have you managed to make the statement

alter user IS grant admin role

work? Or any other alter/create user with an SQL keyword as the user name?
If anybody happened to read somewhere that it's downright impossible,
please post a link so that other people stop wasting their time searching.

thanks
Tomasz

W dniu 2011-09-28 10:53, Tomasz Tyrakowski pisze:

> 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 ==--__
__--==============================--__