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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
