Oracle Database SQLPLUS /

I see my client use SQLPLUS /
to login to DB,
then what account will they use after login to Oracle, is it SYS??
anyone can help?
mawinghoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ehabibConnect With a Mentor Commented:
The '/' tells sqlplus to rely on hosting O/S authentication.
0
 
Peter KwanAnalyst ProgrammerCommented:
0
 
mawinghoAuthor Commented:
does that user require an account in database too?
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>does that user require an account in database too?

Yes. ehabib is correct.  This is OS authentication unless you specify 'as sysdba'.  If you use 'as sysdba' then you are SYS.

Depending on the version of Oracle you are using, you set a configuration parameter.

Check out:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/initparams172.htm#REFRN10152
0
 
mawinghoAuthor Commented:
If I use an OS account to install Oracle
then I can use sqlplus / as sysdba
to login as SYS
however, how does Oracle know oracle is the one who install itself?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You are really asking two different things here.

connect /
and
connect / as sysdba

These are two completely different things and are handled completely differently.

The first one uses OS authentication and connects as just another database user.  The second ALWAYS connects as SYS.

>>how does Oracle know oracle is the one who install itself?

It really doesn't.

As soon as the database sees you try to use 'as sysdba', it doesn't even look at the username or password.

Check it out (assuming you don't have a database user names fred):  
connect fred/flintstone as sysdba


As soon as Oracle sees 'as sysdba' it checks the password file and database groups to see if your OS user is 'allowed' to connect as SYS.  If so, you are connected.  The username and password provided do not matter.
0
 
mawinghoAuthor Commented:
database groups? where can I see which user belong to the this group?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The OS group.  In UNIX it comes from the /etc/group file.  In Windows you can get it from the User Management section in control Panel (and a few other places).

In UNIX it is the dba group.  Windows: ORA_DBA
0
 
mawinghoAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.