Re: dblink as sysdba ?
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: kutrovsky.oracle@xxxxxxxxx
- Date: Thu, 1 Sep 2005 11:31:12 -0400
On 9/1/05, Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx> wrote:
>
> Does anyone know how to create a dblink that connects with sysdba
> priviliges ?
>
> --
> Christo Kutrovsky
> Database/System Administrator
> The Pythian Group
> --
> //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
Other related posts:
