sysdba

  • From: Joshua Collier <jcoll1970@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Oct 2014 10:41:34 -0700

I must have missed something in my years as a DBA, such a basic thing as
understanding this.

1. 11.2.4
2. logged on as oracle on the database host machine ( oracle home and
binaries OS owner)

sqlplus /nolog
connect /as sysdba
create user test identified by test;
grant create session to test;
connect test/test as sysdba;
connected

I am not sure I understand why this user can connect as sysdba without
having been explicitly granted the SYSDBA power? Is it because I am logged
on to the server as Oracle? Is there a machine setting to change this?
documentation is proving sparse on this subject, or my googlefoo has been
found lacking.

thanks for your time,

Josh C.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2014