Re: Insufficient Privileges

The reason, as others have said, is that SYSTEM is not a privilged user, and therefore cannot claim the 'as sysdba' privileges at connect time.

Where I disagree with the other advice given by the other replies to your post is that SYSTEM should NOT be granted the SYSDBA privilege, which would make your connection request work.

SYSTEM is a very powerful user. He has the DBA Role, which means he can practically do anything on the database, as is, and without special intervention. What he cannot do is exercise the SYSDBA privilege, which allows someone to startup, shutdown, backup, recover or create a database. And that's exactly as things should be, because that's what the SYS account is for.

I believe you should maintain the distinction between someone who is GOD and someone who is merely seated at the right hand of the Father. Granting SYSDBA to SYSTEM removes that distinction, and is -imho- an extremely bad idea.

Regards
HJR "Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0210281336.3365f513_at_posting.google.com...
> Hi Experts:
>
> I have my Oracle DB Set up on IBM AIX Server. I have installed Oracle
> Client on my Win XP System
>
> When I start my Oracle Enterprise Manager from my Cleint PC with
> following data:
> --------------------------------
> Username=system
> Passowrd=manager
> Connect as: SYSDBA
> --------------------------------
>
> the System throws "ERROR: ORA-01031: insufficient Privileges" - wonder
> why! Later when I "connect as: NORMAL" - it just works fine.
>
> Does anyone know how to eliminate that Error.
>
> THANKS!
Received on Tue Oct 29 2002 - 01:51:59 CST