Re: dblink as sysdba ?

On 9/1/05, Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:
>
> Does anyone know how to create a dblink that connects with sysdba
> priviliges ?
>
> --
> Christo Kutrovsky
> Database/System Administrator
> The Pythian Group
> --
> http://www.freelists.org/webpage/oracle-l
>

Is that for a dataguard setup?
Databases participating in a primary/standby arrangement perform tasks connected as sysdba.
This is supported via the use of a pre-shared password file.

I can't think of anything else that would need to.

Perhaps you just need to grant a specific sys_priv or tab_priv to a service account to accomplish the task?
Perhaps you just need to logon to the host via ssh to perform the task?

Paul

--
http://www.freelists.org/webpage/oracle-l