--- In firebird-support@yahoogroups.com, "Chris Donges"
<ChrisDonges@...> wrote:

>
>
> How do you remove that role?
>
> > -----Original Message-----
> > From: Alexandre Benson Smith [mailto:iblist@...]
> > Sent: Tuesday, 14 March 2006 8:05 AM
> > To: firebird-support@yahoogroups.com
> > Subject: Re: [firebird-support] Re: Can we "Lock Down"
> > Firebird to keep users from tampering with data?
> >
> > 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
> >
> >
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Visit http://firebird.sourceforge.net and click the Resources

item

> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>

I would try it but I have not been able to successfuly create a
sysdba role in the first place. Have you been able to do so?