Re: Oracle 8.03 Enterprise Manager Login as DBA

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Mar 1999 07:31:51 +0100
Message-ID: <36F5E3D7.77DD540F@sybrandb.demon.nl>

While sysdba is a special privilege granted through the password file. remote_login_passwordfile init.ora parameter should be either shared or exclusive, the default is none. In the former case only SYS and INTERNAL will have sysdba privilege, in the latter case any account can be granted sysdba privilege. This can be done by grant sysdba to <user> and verified by select * from v$pwfile_users.

Hth,

Sybrand Bakker, Oracle DBA

huntbright_at_my-dejanews.com wrote:

> I have an Oracle8.03 on NT, I cannot login as SYSDBA or SYSOPER even using SYS
> or SYSTEM users, login as NORMAL, I found SYS and SYSTEM do have DBA role
> gained, then why cannot I login as SYSDBA to do backup work?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Mon Mar 22 1999 - 00:31:51 CST