Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Nov 29 2006 - 13:34:21 CST