Hi Curtis, two different solutions come to mind. You could wrap your user creation in a stored procedure that does all the heavy lifting: create the user and perform the additional functions Or, you could set up an event which runs regularly, checks if new users have been added, and if that is the case runs aforementioned functions. Hope that helps! -GL 2017-07-07 0:41 GMT+02:00 Curtis Brown <Curtis.Brown@colostate.edu>:
I apologize in advance if this is the wrong venue; please point me in a more correct direction if that's the case.
I want to perform some extra database functions when a new user is created in our MariaDB installation. What I am learning though is that I can't CREATE TRIGGERs against system tables like the user table in the mysql database.
I am using MariaDB v10.1.24 in an Ubuntu 16.04.2 environment
Have others run across a similar situation? Are there techniques to work around this? One thought I had was to enable general query log and either monitor the file output or TRIGGER on the general_log table. Are there any better suggestions? Thanks in advance.
-- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 Colorado State University email: help@colostate.edu curtis.brown@colostate.edu http://lib.colostate.edu/helpdesk/
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp