MySQL Forums
Forum List  »  MySQL Administrator

Re: Trigger not populating USER_CREATED and USER_MODIFIED with user connected
Posted by: Ronan Cashell
Date: July 21, 2011 02:07AM

In MySQL there are two functions to retrieve a user, CURRENT_USER() and USER() (or SESSION_USER() which is an alias for USER()). In the case of your trigger you must use the USER() to get the user executing the INSERT statement.

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Written By
Posted
Re: Trigger not populating USER_CREATED and USER_MODIFIED with user connected
July 21, 2011 02:07AM


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.