Re: Enable/disable database triggers

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/07/21
Message-ID: <33D40691.4D6F@cadvision.com>#1/1

You can grant this user CREATE ANY TRIGGER system privilege.

Wayne Linton
Shell Canada Ltd.

O.K.Man wrote:
>
> When I logon to SQL*Plus with an ordinary user (without DBA privilege)
> ALTER TRIGGER to enable/disable the database trigger of another user, I
> ended up with not enough privilege. Is it possible to allow an ordinary
> user to enable/disable database trigger of another user by granting the
> appropriate rights (except DBA) to the ordinary user ?
>
> Thanks in advance.
>
> O.K.Man
>
> 8-)
Received on Mon Jul 21 1997 - 00:00:00 CDT