Solved

Oracle Database SQLPLUS /

Posted on 2011-03-23
9
493 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:mawingho
9 Comments
 
LVL 16

Expert Comment

by:Peter Kwan
ID: 35196404
0
 

Accepted Solution

by:
ehabib earned 125 total points
ID: 35196497
The '/' tells sqlplus to rely on hosting O/S authentication.
0
 

Author Comment

by:mawingho
ID: 35197778
does that user require an account in database too?
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35197853
>>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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mawingho
ID: 35212753
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
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35214664
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
 

Author Comment

by:mawingho
ID: 35216264
database groups? where can I see which user belong to the this group?
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 375 total points
ID: 35217845
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
 

Author Closing Comment

by:mawingho
ID: 35305474
thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Bulk insert into global temporary table 2 63
oracle query help 36 83
PL/SQL LOOP CURSOR 3 58
Oracle query output question 4 36
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now