Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Link Permissions
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