Re: Newbie question on authentication

Thank you for answering.

Unfortunately when I type connect / as sysdba into svrmgrl the answer is "insufficient privileges". So it's the same with svrmgr. Oracle simply doesn't recognise my Administrator account as a privileged Oracle dba account.

Lee Kyoung Rok <tunnel_at_hananet.net> wrote in message news:eqA_3.592$sI3.22734_at_news.hananet.net...
>
> Alexander Jerusalem <alexander.jerusalem_at_chello.at>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
> news:8Vy_3.7702$Up1.415247_at_news.chello.at¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> > Hi, all
> >
> > I'm new to Oracle and have problems with user accounts, roles and the
> like.
> > My configuration is Oracle 8i on Windows NT 4. My init.ora contains the
> > setting os_authent_prefix = "" and I have an NT group named ORA_DBA
which
> > was created at Oracle installation. The group contains the Domain Admins
> > group and the Administrator account under which I'm currently logged in
to
> > NT. I'm working directly on the database server and I can use sqlplus by
> > specifying internal/oracle or system/manager.
> >
> > The Oracle documentation states that I should now be able to log in by
> > specifying: connect / as sysdba. My first question is where should I
type
> > this in? sqlplus allows me to type this only when I have already started
> > sqlplus. But to start sqlplus I have to specify a user name and
password.
> So
> > that's a circle. What I can do is:
> >
> > sqlplus internal/oracle
> >
> > And then
> >
> > connect / as sysdba
> >
> > But that leads to a message that I have insufficient user rights. I also
> > tried to explicitly create the user Administrator in Oracle like this:
> >
> > create user Administrator identified externally;
> > grant create session to Administrator;
> >
> > But still I cannot log in under this account. Not even by specifying my
> > password although the documentation says that I should be able to log in
> > even without using a password. Is it possible to work with Oracle
without
> > entering username and password? What is identified externally good for
if
> > not for that?
> >
> >
> > Any help would be greatly appreciated.
> >
> >
>
> Execute ServerManager!!! (svrmgr????.exe)
>
>
Received on Tue Nov 23 1999 - 16:27:50 CST