Re: Implicitly get the database connection

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 09 Mar 2004 18:29:01 +0100
Message-ID: <c2kupc$bd7$1@news1.tilbu1.nb.home.nl>

srivenu wrote:
> Martin,
>

>>As far as my knowledge, it&#8217;s implicitly got the target username
>>and password from the first connection, which I gave to connect to
>>database in the beginning.(system/manager).

>
> RMAN always connects as INTERNAL (SYSDBA) to the target database. So
> what you said above is not right.
> In fact connect as scott to SQL*PLUS and give this command.
> host rman target x/y nocatalog
> Even though the user x does not exist or even if the password y is
> wrong, RMAN will connect to the TARGET specified by ORACLE_SID
> variable trying to use OS Authentication.
> It gives an error only if it fails.
> so it will not connect as user SCOTT even if you gave
> host rman target scott/tiger nocatalog
> regards
> Srivenu
>
>
>
> I think you are running

Not true - it's all a matter of the correct privileges. As a matter of fact, I recommend to set up different users than system to run exports and rman backups. It allows you to restrict those account to what they are meant for: full_database_export and RMAN backups

-- 

Regards,
Frank van Bortel

Received on Tue Mar 09 2004 - 11:29:01 CST