try using a on-logon database trigger and see if dynamically revoking
priviledges to prevent dml works for u. this is assuming the trigger is on a
schema which tries dml on tables of a diff schema .. go figure :)
deepAk
-----Original Message-----
From: Rajagopal Venkataramany [mailto:gvrvrr_at_yahoo.com]
Sent: Monday, September 25, 2000 11:49 AM
To: sreeramulu.jai_at_db.com; oracledba_at_quickdoc.co.uk
Subject: Re: Trigger on Schema
Hi,
The understanding is :
Triggers are attached to tables and gets fired
based on table level DML actions.
I do not think atleast any of the current oracle
versions can do this. Your requirement violates
the basic understanding of triggers tied to a
table and not to a schmea owner..
Sorry, I am not able to help u...
Regards
Rajagopal Venkataramany
- sreeramulu.jai_at_db.com wrote:
> Hai all,
> Can any one can help me to write trigger
> on Schema. My requirement is, i don't want allow the
> user to do DML statements on any tables in schema on
> particular condition. I don't want write triggers
> for each table for checking condition. I want write
> trigger on Schema to meet my requirements.
>
> Here i am explaining with examples.
>
> Schema : scott
> tables : emp
> dept
>
> purchase
>
> check(col1 varchar1(10));
> it should allow the user to perform DML if
> col1='Y' otherwise not allowed. For this we can
> write trigger for each table and we can solve this
> problem. But I don't want write trigger for each
> table and i want write trigger on schema for this
> condition.
>
> please if anyone have idea help me.
>
> Thanks & Regards,
> JSR.
>
>
>
> --------
> If you're bored, then visit the list's website:
> http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to
> oracledba-subscribe_at_quickdoc.co.uk
>
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
If you're bored, then visit the list's website:
http://www.lazydba.com
(updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Mon Sep 25 2000 - 14:04:01 CDT