Sebastian Scholz wrote:
> Hello!
>
> I've got a rather complex problem:
>
[...]
>
> Now we have an application which uses the oracle 8I database and the
> same username I used prior in sqlplus to log on to the 8I DB.
> When the App changes a specific table, exactly the same update
> statement should be issued against a table in the 7 DB. So I installed
> a trigger, but I'm getting always an exception.
>
> Why is it possible in the console an UPDATE Statement works and not
> in a Trigger?
> In Development, we're using 8.0.5 and the Procedure worked well, at
> the customer site, however, we're using 8.1.6.
>
Hello Sebastian,
in PL/SQL any roles are disabled. Only the directy granted privileges
count.
So if you are granted the update privilege on the Ora7 DB via a role it
will not work within PL/SQL.
Hope that helps,
Lothar
--
Lothar Armbrüster | la_at_oktagramm.de
Hauptstr. 26 | la_at_heptagramm.de
D-65346 Eltville | lothar.armbruester_at_t-online.de
Received on Fri Aug 17 2001 - 10:47:05 CDT
