Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grant select on all tables of other user
Matthias Hoys wrote:
> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message > news:1112398616.594650_at_yasure... >
> > > OK, but this is not what I would like to do. This way you have to specify > grants for each table. If a new table is added, a new SELECT grant has to be > given. Would it be possible to give this grants automatically each time a > new table is added ? > >
You can do this using a schema trigger.
If you want to see an example code of schema triggers ... try:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1380003556171
Anurag Received on Sat Apr 02 2005 - 06:43:35 CST