Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Enable/disable database triggers
Yes, there is a "Grant alter any trigger ..." command.
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