Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to avoid a public Database link

Re: How to avoid a public Database link

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 23 Aug 2001 05:22:45 -0700
Message-ID: <c18ea449.0108230422.1655d9a6@posting.google.com>


marcus.kuehl_at_t-online.de (waltervdv) wrote in message news:<b2677297.0108222203.4811281e_at_posting.google.com>...
> Hallo !
>
> Can I create a database-link under user A and give access to it to
> user B without creating a public database-link ?
> I dont't think it is possible to gant any priviliges on database-links
> - right?
>
> Thanks in advance
>
> Marcus

In my opinion the only way you can do this is create a stored proc under user A and grant execute to user B. You may have to write the sql in stored proc so that it does dynamic sql Received on Thu Aug 23 2001 - 07:22:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US