Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to avoid a public Database link
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