Re: sysdba and sysoper

From: Van Messner <vmessner_at_bestweb.net>
Date: 2000/06/24
Message-ID: <UN755.2856$Qb1.224362@monger.newsread.com>#1/1

Sysdba and sysoper must be explicitly granted to accounts. The granter must have the right to do this. You can log in as "internal" and grant sysdba and sysoper to accounts. Remember, if the init.ora parameter remote_login_passwordfile is set to SHARED then only internal and sys can have sysdba. If you want other users to have sysdba you must set remote_login_passwordfile to EXCLUSIVE.

Van

Sunny <sunnyb_at_vendtek.bc.ca> wrote in message news:8j0d6o$nua$1_at_newsfeed.smartt.com...
> hi everyone
>
> my question is with my accounts how can i connect as sysdba and sysoper,
> when i try it doesnt let me in, but if i try with normal it works just
fine.
> can anyone please tell me whats the difference between all of them thanks
>
> cheers
> sunny
>
>
Received on Sat Jun 24 2000 - 00:00:00 CDT