Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problems using windows NT networking authentication
Did you remember to set the parameter
remote_os_authent = true
??
Cheers,
Rich
In article <ug154q53t.fsf_at_us.oracle.com>,
Rick Wessman <rwessman_at_us.oracle.com> wrote:
> "Evert J. Smit" <e.smit_at_caiw.nl> writes:
>
> > Hi,
> >
> > I want to connect the users at the office with the same password as
they
> > connect to the domain server.
> > I'm using version Oracle 8.0.4.0.0.
> > What I've tried allready is:
> > * added the line OS_AUTHENT_PREFIX = "" in the init file.
> Good.
>
> > * added the line SQLNET.AUTHENTICATIONS_SERVICES = (NTS) in the
sqlnet.ora
> > file. (There is another line called SQLNET.AUTHENTICATION_SERVICES =
> > (SECUREID) which was allready in the sqlnet.ora file).
> This is probably the cause of the problem. Since there are two
entries in the
> file, Oracle took the first entry. Since you are not using SecurID to
connect,
> the connection will fail.
>
> > * created a user with Sqlplus under the system account with: create
user
> > <example> identified externally
> Good.
>
> > * gave this user example the dba role
> While it's OK to do this, I'm wondering why you the user the DBA
role. This is
> a very powerful role and should not be given to every user.
>
> >
> > I thought this is all you've to do. For testing i restarted the
computer and
> > logged in under useraccount example. So when I tried to connect
Sqlplus with
> > the following command line : sqlplus /@hddb (hddb is the alias
we're using)
> > there comes an ORA message.
> > Which is 'ORA-01004: default username feature not supported; logon
denied'.
> > But I thought that I did everything right.
> > So what did I do wrong ?
> > Can anybody help me out please.
> >
> Hope this helps,
> --
> Rick
> Rick Wessman
> Security and Directory
Technologies
> Server Technologies
> Oracle Corporation
> rwessman_at_us.oracle.com
>
--
Rich Goldkamp, Consultant, OCP RJGoldka_at_dcss.com Digital Consulting & Software Services (504) 523-5005 x2736
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 10 1999 - 12:59:16 CDT