RE: auto grant select

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 29 Nov 2006 14:49:09 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9326950@usahm208.amer.corp.eds.com>

Two main choices:

1 - Procedure - developers issue grants to a role that has been granted to u2 for all u1 objects they create

2 - Develop database event trigger to notice u1 object creation and cause grants to be issued to u2

Mark D Powell -- Phone (313) 592-5148

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tóth István Sent: Wednesday, November 29, 2006 2:34 PM To: oracle-l_at_freelists.org
Subject: auto grant select

Hello,

I have two users in a 9.2.0.5 database (u1, u2) u1 has lot of tables, u2 has a grant select on u1 tables. The developers often create new tables on u1 schema, and u2 can't read these. I'd like to automatically add grant select to u2 on a newly created u1 tables.

Is it possible?

Thanks in advance
Istvan

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 29 2006 - 13:49:09 CST