Subject | Re: [IBO] grant to user ADMIN?? |
---|---|
Author | Helen Borrie |
Post date | 2005-06-06T23:44:41Z |
At 11:01 PM 6/06/2005 +0000, you wrote:
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
>Whats wrong with the next statement?Yes - ADMIN is part of an optional clause for the GRANT 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?
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