Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dblink as sysdba ?
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_at_gmail.com> wrote:
> 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
>
>
-- Christo Kutrovsky Database/System Administrator The Pythian Group -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 01 2005 - 11:27:37 CDT
![]() |
![]() |