OraFAQ Forum: Server Administration » Do not alter user's Trigger ?

Home » RDBMS Server » Server Administration » Do not alter user's Trigger ? (Oracle 10g, cross plat form)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Do not alter user's Trigger ? [message #433358]

Tue, 01 December 2009 22:03

trantuananh24hg
Messages: 747
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!

Report message to a moderator

Re: Do not alter user's Trigger ? [message #433365 is a reply to message #433358]

Tue, 01 December 2009 23:35

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No way unless you go to "database vault" (search for this in Oracle site).

Regards
Michel

Report message to a moderator

Re: Do not alter user's Trigger ? [message #433397 is a reply to message #433358]

Wed, 02 December 2009 02:21

trantuananh24hg
Messages: 747
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Thank you Michel!

Report message to a moderator

Previous Topic:	revoke privilages from public
Next Topic:	Issue in adding LIST partition in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 09 18:34:55 CDT 2026