Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Enable/disable database triggers

Re: Enable/disable database triggers

From: John Harby <nospam_at_allowed.com>
Date: 1997/07/21
Message-ID: <33D3E90E.1536@allowed.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US