Connect as sysdba

TeleMax · Post by **TeleMax** » Mon 17 Jan 2005 15:22

Hello!

Help me please, I can not understand hot to connect as sysdba via TOraSession ?

I need execute
"GRANT EXECUTE ON DBMS_ALERT TO USER"

How can I do this ?

Thank you,
Alexey

Alex · Post by **Alex** » Mon 17 Jan 2005 16:02

You should set 'ConnectMode' property of your TOraSession object to cmSysDBA value, and specify user/password that has enough rights to connect as SysDBA, for example 'Sys' user.

TeleMax · Post by **TeleMax** » Tue 18 Jan 2005 08:55

Alex wrote:You should set 'ConnectMode' property of your TOraSession object to cmSysDBA value, and specify user/password that has enough rights to connect as SysDBA, for example 'Sys' user.

Thank you for useful advise.

...

Is it possible to connect to RMAN ?

Alex · Post by **Alex** » Tue 18 Jan 2005 10:24

The recovery catalog user and password is rman/rman and default SID is OEMREP.
See Oracle Recovery Manager User's Guide for more information about Recovery Manager.