OraFAQ Forum: SQL & PL/SQL » Trigger to prevent update/delete/insert operation

Home » SQL & PL/SQL » SQL & PL/SQL » Trigger to prevent update/delete/insert operation

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

Trigger to prevent update/delete/insert operation [message #657866]

Thu, 24 November 2016 17:09

ram_new_to_oracle
Messages: 1
Registered: November 2016

Junior Member

Hi,

I am new to this forum. I have an assignment in school to do. It is to create a trigger that will not allow user1 to update or delete table1. Also, show the audit results of the update/delete attempts. The Audit must display/show operating system user name, database username, date and action name.

Please let me know.

Thanks!!!

Report message to a moderator

Re: Trigger to prevent update/delete/insert operation [message #657867 is a reply to message #657866]

Thu, 24 November 2016 18:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

BTW, we don't do homework for folks.

Report message to a moderator

Re: Trigger to prevent update/delete/insert operation [message #657870 is a reply to message #657866]

Fri, 25 November 2016 00:54

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Hints:
* PL/SQL Language Reference, Chapter 9 PL/SQL Triggers
* PL/SQL Packages and Types Reference, DBMS_OUTPUT
* SQL Language Reference, SYS_CONTEXT function

Report message to a moderator

Re: Trigger to prevent update/delete/insert operation [message #657872 is a reply to message #657866]

Fri, 25 November 2016 01:15

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

For the second question, you do not need to write any code at all: configuring either standard database audit (in release 11.x) or Unified Audit (release 12.x) will do this.

Report message to a moderator

Re: Trigger to prevent update/delete/insert operation [message #657880 is a reply to message #657872]

Fri, 25 November 2016 03:18

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

I rather imagine the question states that the trigger needs to write the audit records.

Report message to a moderator

Previous Topic:	Trigger to prevent delete according to select
Next Topic:	using rownum

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:00:44 CDT 2024