Re: whither user trace file?

From: Thomas Kyte <thomas.kyte_at_oracle.com>
Date: 4 Aug 2005 07:22:29 -0700
Message-ID: <133165349.000025fa.084@drn.newsguy.com>

In article <1123084398.690336.168240_at_o13g2000cwo.googlegroups.com>, EdStevens says...
>
>Hmm. Well, SYSTEM alerady had the DBA roll, which has ALTER SESSION,
>but when I granted ALTER SESSION directory to SYSTEM, everything
>worked.
>
>More reading on my plate ... ;-)
>

see
http://asktom.oracle.com/~tkyte/Misc/RolesAndProcedures.html

for why the owner of the trigger needed the privilege directly.

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation

Received on Thu Aug 04 2005 - 09:22:29 CDT