Re: Give ROOT account access to SQLDBA (connect internal)

Jeff,

  You need to create an ops$daemon account in the database, then grant all privileges to the ops$daemon account. Once you do that you should be able to connect internal as root (I've used the ops$ prefix here - if you've set your os authentication prefix differently, use that one).

Steve
smiller_at_gers.com

Jeff Shervey <jeff.shervey_at_us.landisstaefa.com_spamblock> wrote in article <01bc93b3$0b2367b0$1fea1bac_at_usbgrjeff>...
> I think I've seen this posted before..but here goes:
>
> I'm running DEC UNIX and need the ROOT account to have access to SQLDBA
> utility:
>
> sqldba lmode=y
> connect internal;
> password:
> ORA-01031: insufficient privileges
>
> It prompts me for a password when connecting internal. I added the root
> account to the UNIX dba group.
>
> Jeff S.
>
>
> --
> My famous quote while canoeing in Canada last
> year "Whether we stay or go, either way, we die"
> Jeff Shervey - Oracle/Ingres DBA
> Landis and Staefa
> Buffalo Grove, IL
>
  Received on Wed Jul 30 1997 - 00:00:00 CDT