Re: Select Privileges

From: ddf <oratune_at_msn.com>
Date: Thu, 17 Nov 2011 20:31:20 -0800 (PST)
Message-ID: <ad8f6248-570b-4d92-9c22-ad09f5eae5e3_at_d37g2000prg.googlegroups.com>



On Nov 17, 12:16 pm, ExecMan <artme..._at_yahoo.com> wrote:
> Hi, I'm trying to get the following scenario to work.  Maybe someone
> can help?
>
> We have the following small setup:
> DATABASE: DB1
> USERS:  TOM & BILL, CHRIS, MARK, JOE
>
> DATABASE: DB2
> USERS: TOM
>
> There is a trigger on a table in Tom's schema in DB1.  That trigger
> will insert data into a table in Tom's schema on DB2, over a DB link.
>
> I want to grant SELECT access to CHRIS only so he can query the table
> in Tom's schema on DB2.  I do not anyone else to be able to select
> from the table.
>
> How can this be done, since the dblink logs in under a given user
> account?  Can permissions somehow be given to use of database links?
> Or by source user?
>
> Thanks

No. You could create a read-only user in DB2 that can select from Tom's table then create a private db link in CHRIS' schema using that read-only user so he, and only he, can access that object.

David Fitzjarrell Received on Thu Nov 17 2011 - 22:31:20 CST

Original text of this message