Re: Grant select on all tables of other user

On Sat, 02 Apr 2005 11:42:20 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

>> You cannot perform an object grant in a DDL-trigger (at least not in
>> Oracle 8, maybe it changed in a later version).
>
>Not in any version with any trigger type.

 See: http://asktom.oracle.com/~tkyte/autonomous/

 Scroll down to the "Performing DDL in triggers" for methods that'll work on any current version. In short: autonomous transactions, or DBMS_JOB - to get the DDL (which would try to commit) outside the trigger's transaction.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool