Re: Oracle Enterprise Manager, Password for Internal

Doug Moloney wrote:
>
> One of my DBA's has indicated that they can not give me Oracle
> Enterprise
> manager because it allows me to connect internal and I could do
> potential
> damage to the database. Can anyone tell me if this is true.
> Considering
> that the Internal account uses the same password as SYS, if they change
> the password for the SYS account, and I (normal user - not dba) launch
> Oracle Enterprise Manager will I be able to connect internal without
> knowing the password? Shouldn't I have the same rights that I normally
> have when I use SQLPlus, or any other tool that connects?
>
> Please respond direct to
>
> Doug.Moloney_at_ae.ge.com
> Phone:(513)786-5596, 8*730-5596
> GE Aircraft Engines
> Materials Management Systems

Doug,

This is only true when using the SYS login, which is exactly what it is intended for, hence the reason it's password should be closely guarded. However, if you use the SYSTEM account, even with the granted DBA role, and attempt a SYSDBA connection, it should be refused with an 'insufficient privileges' response if the password file is set up properly.

Please note that this capability is not limited to Enterprise Manager, but any utility that offers the fourth option field in the login window.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.