Re: AFTER LOGON ON SCHEMA Trigger 8.1.6 .. HELP!

From: Ura! <ura_at_ymz.yaroslavl.ru>
Date: Mon, 14 May 2001 03:45:26 -0700
Message-ID: <F001.00302656.20010514035020@fatcity.com>

Arul,

---

Ak> Hi Everybody,

Ak> I am using oracle 8.1.6 db.

Ak> I want to create a trigger which fires for every new object created in a
Ak> particular schema. Basically,  i want to grant privileges for this newly
Ak> created object  to Roles, Users dynamically as and when the new object
Ak> created.


Ak> When i tried , the trigger  got created but on creating a table in that

Ak> schema reported that " DDLs are not allowed in System triggers except Ak> ALTER....COMPILE... " - command failed.

Ak> Is there any workaround to achieve issuing DDLs ? include pragma autonomous_transaction; as shown below

CREATE OR REPLACE TRIGGER FORMROLE_DEL
 AFTER DELETE ON FORMROLE
FOR EACH ROW
DECLARE
pragma autonomous_transaction;
....
BEGIN
...
END FORMROLE_DEL

---

ura_at_ymz.yaroslavl.ru
 Ura!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ura!
  INET: ura_at_ymz.yaroslavl.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 14 2001 - 05:45:26 CDT