963587 wrote:The optimal solution would be a TRIGGER on each table.
I have a access to table say Table A,Table B and Table C . I have no access to modify or to add any column in Table A or Table B or Table C. I have only access to read table entries of Table A ,Table B and Table C. Entries of these tables are updated by owner of the table. I have created a view of Table A, Table B and Table C with required column by my module.
Now there is requirement that my module should also log Timestamp when any particular row of Table A has been last updated .There is no column in any table A ,B or C that has time stamp entries .
Please help me out to resolve this problem.