Subject Re: [IBO] grant to user ADMIN??
Author Helen Borrie
At 11:01 PM 6/06/2005 +0000, you wrote:

>Whats wrong with the next statement?
> SQL-> grant all on CON_BANCOS to user ADMIN
>
>when I try to execute it, Firebird throw me the following
>exception:
>
>ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 1, char 33
>ADMIN
>
>Statement: frmWISQL.dsqlEdit
>
>is "ADMIN" or "admin" a reserved work or something?

Yes - ADMIN is part of an optional clause for the GRANT statement:

GRANT ALL ON CON_BANCOS TO OWNER WITH ADMIN OPTION

IMO, it's a bug that you can create a user named ADMIN at all.

Helen