Skip navigation links

MySQL Forums :: Information Schema :: Trigger on information_schema.routines


Advanced Search

Trigger on information_schema.routines
Posted by: Michal Koba ()
Date: December 24, 2009 06:30AM

I need to develop functionality based on changes in information_schema.routines. But - when I try to add classic trigger on then object MySQL give me following error: Access denied for user 'root'@'%' do database 'information_schema'.

EDIT: After reading some other topics on this forum I learned that information_schema.routines is View type object.

Is there any chance to hook somewhere with trigger to catch changes in information_schema database ?

Options: ReplyQuote


Subject Views Written By Posted
Trigger on information_schema.routines 6408 Michal Koba 12/24/2009 06:30AM
Re: Trigger on information_schema.routines 3626 Devart Team 12/24/2009 09:25AM
Re: Trigger on information_schema.routines 2948 Michal Koba 12/26/2009 04:50AM
Re: Trigger on information_schema.routines 2766 Michal Koba 12/28/2009 04:55AM
Re: Trigger on information_schema.routines 2226 Goran Gugic 03/24/2010 06:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.