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

Written By
Trigger on information_schema.routines
December 24, 2009 06:30AM

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.