Page 1 of 1

Connect as sysdba

Posted: Mon 17 Jan 2005 15:22
by TeleMax
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

Posted: Mon 17 Jan 2005 16:02
by Alex
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.

Posted: Tue 18 Jan 2005 08:55
by TeleMax
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 ?

Posted: Tue 18 Jan 2005 10:24
by Alex
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.