Walt schreef:
>
> Continuing the conversation with myself... the *right* way to do this is
> not with views, but with packages or stored proceedures.
>
> Privileged user A owns the link and creates stored procs or packages
> that do what needs to be done. A grants execute rights on the proc to
> users B and C.
>
> This way, users B and C can't see or do anything on the remote database
> that's not allowed by the proc.
>
> Obvious, eh?
>
And a valid approach for *any* object, not just db links.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sat May 13 2006 - 10:43:10 CDT
