RE: auto grant select
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 14:49:09 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Tóth István
Sent: Wednesday, November 29, 2006 2:34 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
