Re: sysdba

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 28 Sep 2001 21:36:52 +0200
Message-ID: <tr9kpt6asmpm87@news.demon.nl>

"Peter Shvets" <pshvets_at_powermarket.com> wrote in message news:9p2ier$1k6d$1_at_news.mainstreet.net...
> Hello, everybody.
> Please, refresh my memory on how to make user system to connect as sysdba.
> I know I need to modify password file, just forgot the syntax. :)
> Now I am getting the following:
> SQL> connect system/manager_at_dev as sysdba
> ERROR:
> ORA-01031: insufficient privileges
>
> Thank you.
> Peter.
>
>

system doesn't have sysdba privilege unless explicitly granted. you need to use sys or / as sysdba when you are on the db server.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 28 2001 - 14:36:52 CDT