Tag Info

New answers tagged

0

Unless you create a different database user for each application user -so it is available with the user() or current_user() functions: mysql> SELECT user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) mysql> SELECT current_user(); +----------------+ | current_user() | ...


1

I will elaborate on the @Jeffrey Kemp's comment. Since the information about authors of modifications is not collected in the objects' metadata, you will want to use database auditing mechanisms. As per Verifying Security Access with Auditing chapter of Database Security Guide, there are several types of auditing, but Standard Auditing is probably the ...


0

If you want to see who issued shutdown from a Linux viewpoint and if you are real risk taker, I have a very dangerous but fun suggestion. You could create a special log file that records when service mysql stop is issued or if mysqld_safe decides to shutdown. Let's say you want the file to be called /var/lib/mysql/.shutdown_signals Run the following two ...



Top 50 recent answers are included