Re: dblink as sysdba ?
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>
- Date: Thu, 1 Sep 2005 11:43:08 -0400
Actually, i want to create a dblink to the ASM instance, so that I
dont have to connect to it everything i want to see what's going on :)
On 9/1/05, Paul Drake <bdbafh@xxxxxxxxx> wrote:
> 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
>
>
--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
