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

Home -> Community -> Usenet -> c.d.o.server -> Re: Can an account login with either "/" or username/password?

Re: Can an account login with either "/" or username/password?

From: JB <nospam-randolph-nospam_at_plantnet.com>
Date: Wed, 27 Feb 2002 04:25:57 GMT
Message-ID: <hdno7ucl9u50c3nogf0bc5r1e11om964tg@4ax.com>


Yeah, I have tried that as well. Basically, I just need to be able to create the user in the database with a password and still be able to access the account from sqlplus with the slash. If I create the user identified as external, I can only attach to the database using the "/."

Right now my OS_AUTH_PREFIX is set to ""

JB

On Wed, 27 Feb 2002 03:55:03 GMT, "J Alex" <jalexanderssd_at_yahoo.com> wrote:

>
>"JB" <nospam-randolph-nospam_at_plantnet.com> wrote in message
>news:1jko7uk5u2divsr1k79k3e1jm345qd7r36_at_4ax.com...
>> Is it possible to create an account that can logon with either the "/"
>> or username/password combo from sqlplus?
>>
>> I have a need to create a user which can either login with a slash, or
>> enter the username/password information. For instance, I create a
>> user:
>>
>> CREATE USER USER1 IDENTIFIED BY PASSWORD
>>
>> If I connect to SQL*Plus, I get the following messages:
>>
>> CONNECT USER1/PASSWORD_at_DB - Connected
>> CONNECT /@DB - ORA-01017 error
>>
>> If I create the user identified externally:
>>
>> CREATE USER USER1 IDENTIFIED EXTERNALLY
>>
>> I get the following messages when I connect to SQL Plus:
>>
>> CONNECT USER1/PASSWORD_at_DB - ORA-01017 error
>> CONNECT /@DB - Connected
>>
>> Is there some way to configure the server and client to allow
>> connections either way with a single account?
>>
>> Thanks
>>
>> JB
>Look at using OPS$ accounts. There are some cross-platform restrictions, but
>could be they will meet your needs. Basically its like what you did except
>with an OPS$ in the username:
>CREATE USER OPS$<unix_user> IDENTIFIED EXTERNALLY;
>
>If you search on Metalink for OPS$ you'll see some examples and the
>limitations.
>
Received on Tue Feb 26 2002 - 22:25:57 CST

Original text of this message

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