OraFAQ Forum: Security » conn /as sysdba;

Home » RDBMS Server » Security » conn /as sysdba; (Solaris, Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

conn /as sysdba; [message #359751]

Tue, 18 November 2008 02:25

Erdenejargal
Messages: 18
Registered: July 2008

Junior Member

Hi there,

I'm using Oracle 9i, Solaris 10.
I entered Oracle:

sqlplus /nolog;

SQL> conn /as sysdba;
Connected.
SQL>show user;
USER is "SYS"
SQL>

And I just want to know what's my account.
SYS user had password.

I don't understand why it is not asking sys user's password.
Embarassed

Report message to a moderator

Re: conn /as sysdba; [message #359760 is a reply to message #359751]

Tue, 18 November 2008 02:34

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

An administrative account is a user that is granted SYSOPER or SYSDBA privileges.
Oracle DBAs and operators typically use administrative accounts to manage the database and database instance.

SYSDBA and SYSOPER allow access to a database instance even if it is not running.
Control of these privileges is managed outside of the database via password files
and special operating system groups (dba on Unix/Linux and ORA_DBA on Windows).
External password files are created with the orapwd utility.

Quote taken from http://www.orafaq.com/wiki/Oracle_database_Security_FAQ

Report message to a moderator