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