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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
