> > How to delete SYSDBA role when SYSDBA is database owner ?
>
> You can't. Your best hope is to either data pump, or I think there is
> a tool around somewhere that can change the owner (which may or may
> not work).

That being said -> there's no real point in blocking SYSDBA
access if SYSDBA is the owner :-)


Use a different user as the owner of your database and objects
and only then try to block sysdba access.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com