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: 744
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: 68665
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

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: 744
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 Jul 01 00:23:16 CDT 2024