Re: DB Links

davidr_at_languageline.com (David) wrote in news:5c7c761.0109101417.402d5a54 @posting.google.com:

> Oracle 8.1.6.3
>
> I have a public db link that I want to keep one user from using is
> this possible? Creating individual db links would be a nightmare.
>

While this may NOT be an elegant solution, it might work for you. Then again, it might not.

1. remove the PUBLIC DB link
2. create a logon trigger
3. For everybody but Mr. Problem Child, create a private db link when they login; if one already does not exist.