Home » RDBMS Server » Server Administration » Do not alter user's Trigger ? (Oracle 10g, cross plat form)
Do not alter user's Trigger ? [message #433358] Tue, 01 December 2009 22:03 Go to next message
trantuananh24hg
Messages: 664
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi!

I've one question about privileges:

In my schema - user LOG, I created a trigger to capture any logfile appeared in some tables. But I do not want any user who have got DBA role can alter my trigger?

But I did not think any way to do, may you help me?

Thank you!
Re: Do not alter user's Trigger ? [message #433365 is a reply to message #433358] Tue, 01 December 2009 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way unless you go to "database vault" (search for this in Oracle site).

Regards
Michel
Re: Do not alter user's Trigger ? [message #433397 is a reply to message #433358] Wed, 02 December 2009 02:21 Go to previous message
trantuananh24hg
Messages: 664
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you Michel!
Previous Topic: revoke privilages from public
Next Topic: Issue in adding LIST partition in a table
Goto Forum:
  


Current Time: Sat Oct 01 12:39:23 CDT 2016

Total time taken to generate the page: 0.08772 seconds