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