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

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Mon, 14 May 2001 08:40:29 -0700
Message-ID: <F001.0030297A.20010514075056@fatcity.com>

Allowing people to create objects on the fly sounds like bad news to me...

Anyway, one possible workaround would be to have your trigger schedule a dbms_job to perform the grants. Then your grants would take place shortly after the ddl had been performed...

hth
connor

• Arul kumar <rakumar_at_mahindrabt.com> wrote: > Hi Everybody,
  >
  > I am using oracle 8.1.6 db.
  >
  > I want to create a trigger which fires for every new
  > object created in a
  > particular schema. Basically, i want to grant
  > privileges for this newly
  > created object to Roles, Users dynamically as and
  > when the new object
  > created.
  >
  > When i tried , the trigger got created but on
  > creating a table in that
  > schema reported that " DDLs are not allowed in
  > System triggers except
  > ALTER....COMPILE... " - command failed.
  >
  > Is there any workaround to achieve issuing DDLs ?
  >
  > Thanks.
  >
  > Regards,
  > Arul.
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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 - 10:40:29 CDT