> > What if the database, and the objects and privileges, were created by
> > SYSDBA, prior to creating the role SYSDBA? That would be catch-22, I

think....

>
> You can't create SYSDBA role if there already are objects owned by SYSDBA
> (or grants to SYSDBA). Try it.

INSERT INTO RDB$ROLES ?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com