Re: password for sysdba

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 20 Dec 2003 21:07:11 +0100
Message-ID: <bra9uv4u3oj95lsgsa1u8c4q4nl9dndkpm@4ax.com>

On Sat, 20 Dec 2003 13:19:16 -0500, "Oracle Learner" <hastenthunder_at_yahoo.com> wrote:

>Hi,
>
>I've created a test database on the linux machine (Red-Hat 9). I found that
>any user can connect as sysdba as follows:
>
>SQL> connect user as sysdba
>Enter password: -- I entered a random value
>Connected
>SQL>
>
>I'm very confused at this, is there a password for sysdba?
>

If your unix account is in the dba group you are OS authenticated. This will allow you to get in even when the database is in nomount or mount state. It is perfectly normal.
You shouldn't be using the oracle unix account for everyday operation, it is always in the dba group. Any other unix account will need a password unless you allow it to use the dba group.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Dec 20 2003 - 14:07:11 CST