RE: grant select on SCOTT.* to vewalluser;

From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
To: Roger.Xu@xxxxxxxxxxx
Date: Tue, 31 Oct 2006 09:56:10 -0800

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@xxxxxxxxxxx>:

> 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

References:

RE: grant select on SCOTT.* to vewalluser;
From: Roger Xu

RE: grant select on SCOTT.* to vewalluser;

Other related posts: