Re: Privileges Database Link

From: The Magnet <art_at_unsu.com>
Date: Mon, 24 May 2010 13:52:25 -0700 (PDT)
Message-ID: <1f358ba2-391c-42d8-b9b1-a28a84048f13_at_11g2000prv.googlegroups.com>

On May 24, 3:49 pm, Shakespeare <what..._at_xs4all.nl> wrote:
> Op 24-5-2010 20:18, The Magnet schreef:
>
>
>
>
>
> > We have 2 database which have DB links between.  The user in both
> > database have the same name.  We cannot figure out how to grant the
> > privileges.
>
> > SQL>  grant select on status to j..._at_comm.zacks.com;
> > grant select on status to j..._at_comm.zacks.com
> >                                      *
> > ERROR at line 1:
> > ORA-00933: SQL command not properly ended
>
> > SQL>  grant select on status to john;
> > grant select on status to john
> >                            *
> > ERROR at line 1:
> > ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
>
> > Help please.
>
> Your database link connects through a user in the target database.
> Grants should be done IN the target database by an account with the
> privileges to do so. You can not grant over the link.
>
> Shakespeare

Right, but take this:

DB1

---

USER: JOHN
TABLE: TAB1 DB2

---

USER: JOHN
TABLE: TAB1 I cannot grant a privilege to myself. I mean, the user names are the same, and I am having trouble with that part, unless I am missing something. Received on Mon May 24 2010 - 15:52:25 CDT