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
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