dbagregc wrote:

> --- 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.
>

Create some role.
Modify RDB$ROLES, rename your role to SYSDBA

HTH
Radu