At 08:32 AM 4/10/2011, Tomasz Tyrakowski wrote: >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.
Let's put it this way: it *shouldn't* be possible with a Dialect 1 database. Reason: IS is a reserved word in Fb 2.5. The only way to refer to that identifier in SQL would be to double-quote it. The double-quote feature is not supported in Dialect 1. The interesting part is how you managed to have this identifier existing unquoted in your v.11.2 security database. The only way I can think of is that it has been progressively upgraded as a Dialect 1 database since IB 4 times. ./hb
