Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle users and /etc/passwd coordination?
hi, karl,
yes, you have to create users inside the database.
"create user OPS$Username identified externally".
Afterwards, when you're logged in to the OS as Username, try
"sqlplus /".
This will do the job.
karl_at_f7.net schrieb:
>
> I just installed a brand-new oracle database on Solaris 2.7, oracle
> version 8.0.5. I have a question about defining users so our
> programmers can have access to it.
>
> The manuals (solaris admin reference page 2-23ff) says that if I put
> OPS_DOLLAR_LOGIN_ALLOWED in /var/opt/oracle/listener.ora, operating
> system accounts will automatically be enabled. I think I don't
> understand what this means. I did that, then ran lsnrctl reload. But
> then giving some ops$user & pw to the sqlplus user-name: and password:
> prompts doesn't work (invalid username/password; logon denied) for a
> valid Unix user/pw (defined in /etc/passwd).
>
> Do I have to issue an sql create user command for every user who needs
> access to oracle? No way to just have oracle automatically say `if
> you're in /etc/passwd, ok'? I suppose this is ok, but the manual
> implied otherwise, so I am confused.
>
>
> Thanks in advance,
> karl_at_f7.net
Received on Fri Jan 29 1999 - 07:43:01 CST