Re: PREVENT DB-LINK FOR A USER

From: Bill Petty <pettyb_at_cadvision.com>
Date: 1997/06/09
Message-ID: <5nhdcg$1pqa@elmo.cadvision.com>#1/1

qutub_at_hotmail.com writes: > How to prevent Database Link Access for a user.
> We dont want particular user to access remote database tables.
>
> Thanks .
>
> SDQ.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

It depends how you are using the DBlink. If it is a PUBLIC link and the user has no authority for objects (i.e. tables) in the remote DataBase s/he cannot access them.

If it is a PRIVATE link using local views of remote tables - don't grant the user access to the views.

Hope this helps.

Bill Petty
DBA
Fording Coal Limited Received on Mon Jun 09 1997 - 00:00:00 CDT