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