Re: Check user roles in trigger?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 31 Mar 2004 19:00:32 +0200
Message-ID: <b7ul601ctcvvso4hokoth3i301hq0adou8@4ax.com>

On 31 Mar 2004 07:13:42 -0800, drdrudge_at_hotmail.com (Dr Drudge) wrote:

>I have a requirement to check a user's role before allowing update of
>a column. Briefly, some roles are always permitted to update, others
>are permitted only if the "OLD" value is NULL.

This simply means the privileges granted to the role are incorrect, otherwise you wouldn't have need to check. You should cure the problem, not work around it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Mar 31 2004 - 11:00:32 CST