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