I need to create an equivalent sysdba user which can run shutdown, startup, create tablespaces, etc etc but can't run select,update,insert and delete from the eschemas.
Is possible this ???
I saw that you must be sysdba (connect as ) to create tablespaces and shutdown the database, but the sysdba can make salect any table.
4) grant select any dictionary (for read v$ & dba_)
revoke GRANT ANY PRIVILEGE from username; revoke GRANT ANY OBJECT PRIVILEGE from username;
revoke select any table from username; revoke insert any table from username; revoke update any table from username;
If anybody know a bug with this please tell me.
Thanks a lot !