Home » RDBMS Server » Security » conn /as sysdba; (Solaris, Oracle 9i)
conn /as sysdba; [message #359751] Tue, 18 November 2008 02:25 Go to next message
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
Re: conn /as sysdba; [message #359760 is a reply to message #359751] Tue, 18 November 2008 02:34 Go to previous messageGo to next message
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
Re: conn /as sysdba; [message #359767 is a reply to message #359760] Tue, 18 November 2008 02:41 Go to previous messageGo to next message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
thanks for your quick reply.
Re: conn /as sysdba; [message #359768 is a reply to message #359760] Tue, 18 November 2008 02:42 Go to previous message
Erdenejargal
Messages: 18
Registered: July 2008
Junior Member
Thank you,
I got it.
Previous Topic: sequence to change db users passwords
Next Topic: Databse login problem
Goto Forum:
  


Current Time: Fri Mar 29 06:50:46 CDT 2024