RE: grant select on SCOTT.* to vewalluser;

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 31 Oct 2006 09:56:10 -0800
Message-ID: <1162317370.45478e3ac19a2@webmail.hosting.telus.net>

This you can automate using a trigger on the create. Not sure it's available pre-9i, but in 9i (9.2.0.6) I've done it. Of course you have to work around the fact that you can not do DDL in a trigger.

Quoting Roger Xu <Roger.Xu_at_dp7upbg.com>:

> Then each time SCOTT creates a new table, I have to do the following?
>
> grant select on SCOTT.newtablename to vewalluser;
>
>

-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

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

Received on Tue Oct 31 2006 - 11:56:10 CST