Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

restrict - sqlplus / as sysdba

BoochiMar 13 2008 — edited Mar 13 2008

This might be a basic question. But, I don't have answer for this. How to restrict the sysdba access.
I can connect any user as sysdba. This will display all the system objects. How to restrict this access. Infact, there are no DBA previleges granted to scott.
Ex:
SQL> connect / as sysdba
SQL> connect scott as sysdba

Any help is appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2008

Added on Mar 13 2008

#general-database-discussions

16 comments

8,219 views