Re: sysdba

From: Seth Miller <sethmiller.sm@xxxxxxxxx>
To: Joshua Collier <jcoll1970@xxxxxxxxx>
Date: Thu, 16 Oct 2014 15:39:08 -0500

Josh,

If you want to login with the test user, you have to use a different
connection method. Right now you are using operating system authentication
which overrides all other authentication methods.

Try this:
sqlplus /nolog
connect test/test@//localhost/<service name> as sysdba
  OR
connect test/test@<tnsnames.ora entry> as sysdba

Seth Miller


On Thu, Oct 16, 2014 at 12:41 PM, Joshua Collier <jcoll1970@xxxxxxxxx>
wrote:

> 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.
>

References:
- sysdba
  - From: Joshua Collier

Re: sysdba

Other related posts: