Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: howto connect as / with sqlplus

Re: howto connect as / with sqlplus

From: Rick Wessman <Rick.WessmanNO_SPAM_at_NoOrSaPcAlMe.com>
Date: 7 Feb 2007 11:39:59 -0800
Message-ID: <eqd9uf01tmo@drn.newsguy.com>


In article <45CA06FD.70808_at_arcor.de>, Maxim Demenko says...
>
>DA Morgan schrieb:
>> Bruintje Beer wrote:
>>> Hi,
>>>
>>> How can I logon to sqlplus using
>>>
>>> sqlplus /
>>>
>>> thanks
>>>
>>> John
>>
>> 1. Be physically on the server.
>> 2. Be a member of the operating system DBA group.
>> 3. In SQL*Plus, in the User Name location, type / as sysdba
>
>I don't think, the question was about "/ as sysdba".
>To OP:
>To connect with / you have possibilities
>1) user identified globally (by means of LDAP) - no need to be on the
>server (connect string can be leaved if you set TWO_TASK/LOCAL variables)
>2) user identified externally - should be locally on server
>3) user identified externally as 'certificate DN' - no need to be local
>on server.
>
>You can look up some examples nicely explained by Fabrizio Magni:
>http://nextre.it/oracledocs/certificates01.html
>http://nextre.it/oracledocs/certificates02.html
>
>Best regards
>
>Maxim

Or you could use Oracle Advanced Security.

-- 
                                Rick Wessman
                                Oracle Corporation
     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.
Received on Wed Feb 07 2007 - 13:39:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US