Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: howto connect as / with sqlplus
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