--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> dbagregc wrote:
> >
> > I tried to create a role called sysdba and it would not let me

do

> > it. It says "This operation is not defined for system tables.
> > unsuccessful metadata update. user name SYSDBA could not be

used

> > for SQL role." The steps I took were to log on as sysdba,

create a

> > new user, log on as the new user, then tried to create role

called

> > sysdba. Any suggestions?
> >
> I think it should be:
>
> Log as SYSDBA
> create the SYSDBA role
> logout
> try to log as SYSDBA (should fail)
>
> never tried it, but I think that should be this way.
>
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>

I tried this and it did not work either. It could be the fact that
I am doing this through IBExpert, but I would assume that it has the
same functionality that you get from talking to the database through
ODBC and the firebird utils.