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