>-----Original Message----- >From: Pedro [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 23, 2008 6:48 PM >To: Dan Nelson >Cc: mysql@lists.mysql.com >Subject: Re: Log > >I need to pass the user of my application pro bank. >I want to log the user's application and value of new fields or fields >updated. To then have audit of who did what. > [JS] We do this in our programming, where it is perhaps easier to tell which fields are being changed. We then log the changes into a log table:
mysql> desc prod_chg; +--------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+-------+ | chg_id | varchar(15) | NO | PRI | | | | prod_id | varchar(15) | NO | | | | | prod_num | mediumint(6) | YES | | NULL | | | prod_title | varchar(255) | YES | | NULL | | | prod_type | varchar(2) | YES | | NULL | | | prod_vat_pct | decimal(5,2) | YES | | NULL | | | prod_discont | tinyint(1) | YES | | NULL | | | prod_ready | tinyint(1) | YES | | NULL | | | pub_id | varchar(15) | YES | | NULL | | | prod_published | date | YES | | NULL | | | prod_pub_prod_id | varchar(255) | YES | | NULL | | | prod_pub_acct_id | varchar(2) | YES | | NULL | | | prod_pub_doi | date | YES | | NULL | | | prod_pub_resp | date | YES | | NULL | | | prod_pub_prod_url | varchar(255) | YES | | NULL | | | prod_rel_freq | smallint(3) | YES | | NULL | | | prod_content_info | varchar(255) | YES | | NULL | | | prod_info_type | varchar(5) | YES | | NULL | | | prod_language | varchar(50) | YES | | NULL | | | prod_broch_doc | varchar(255) | YES | | NULL | | | prod_samp_doc | varchar(255) | YES | | NULL | | | prod_samp_pgs | varchar(255) | YES | | NULL | | | prod_exec_summ | varchar(255) | YES | | NULL | | | prod_toc_doc | varchar(255) | YES | | NULL | | | prod_e_title_tag | varchar(255) | YES | | NULL | | | prod_meta_tags | varchar(255) | YES | | NULL | | | prod_keywords | varchar(255) | YES | | NULL | | | prod_comments | text | YES | | NULL | | | prod_if_sample_pdf | varchar(255) | YES | | NULL | | | prod_stop_date | date | YES | | NULL | | | prod_hide_web | tinyint(1) | YES | | NULL | | | prod_changed | tinyint(1) | YES | | NULL | | | prod_export | tinyint(1) | YES | | NULL | | | prod_scoop_changed | tinyint(1) | NO | | 0 | | | prod_on_scoop | tinyint(1) | NO | | 0 | | | prod_added | datetime | YES | | NULL | | | prod_updated | datetime | YES | | NULL | | | chg_date | date | YES | | NULL | | | chg_fields | text | YES | | NULL | | | chg_action | char(1) | YES | | NULL | | | chg_staff_id | varchar(15) | YES | MUL | NULL | | +--------------------+--------------+------+-----+---------+-------+ >It is really necessary to create a trigger and a table of log for each >table that want to monitor? > >What do you suggest me? > >Dan Nelson escreveu: >> In the last episode (Jul 23), Pedro Belmino said: >> >>> I do a system log of their log everything that is done(INSERTS, >UPDADES >>> and DELETES). Okay, can be done with trigger. But I need to know who >>> performed the operation. How can I get get it inside the trigger? >>> >> >> Try the USER() or CURRENT_USER() functions: >> >> http://dev.mysql.com/doc/refman/5.0/en/information- >functions.html#function_user >> http://dev.mysql.com/doc/refman/5.0/en/information- >functions.html#function_current-user >> >> > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]