Re: HowTo: Trigger for Change- Logging

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 16 Sep 2005 21:10:43 +0200
Message-ID: <dgf4sq$tt1$1@news2.zwoll1.ov.home.nl>

Andreas Mosmann wrote:
> DA Morgan schrieb am 15.09.2005 in <1126810815.866553_at_yasure>:
>

>> If your access is granted via a role that is insufficient. You must
>> grant explicitly for PL/SQL.

>
> This I could not imagine. I did not know there is a difference between
> both cases and so I supposed that there is no lack on rights when I can
> query as user.

You may not be logged on when this trigger fires - how is Oracle to know what role grants are active?

You should always test pl/sql with 'set role none', effectively switching off any roles. You cannot switch off direct object grants - you can only revoke them.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Sep 16 2005 - 14:10:43 CDT