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
Rene Nyffenegger wrote:
>>>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
Ah .. I found an example given by Tom Kyte himself .. which is on the same lines as mine .. however, more concise and better:
Anurag Received on Sat Apr 02 2005 - 14:16:15 CST