TRIGGER
Posted by:
P L
Date: March 15, 2015 03:09PM
Hello Boyz and Girlz!
I'm a newbie so thats why Im here.
I need to create TRIGGER that will be kind of LOG. I want it to check what users do. Sooo...
I made something like that
CREATE TABLE Log (
UserName varchar(20),
Action varchar(20),
Date datetime);
CREATE TRIGGER Watch AFTER UPDATE ON ORDERS
AS INSERT INTO Log(UserName, Action, Date) VALUES (SYSTEM_USER, ???, GETDATE());
this fragment of SQL code worked in MSSQL Server but here in MySQL didnt.
My problem is that i dont know the correct function to get UserName and kind of action this user use.
COULD YOU HELP ME?
Your faithfully NEWbIE
Subject
Written By
Posted
TRIGGER
March 15, 2015 03:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.