Showing entries 1 to 3
Displaying posts with tag: definer (reset)
Mar
23
2015
How to fix definer does not exist error 1449 MySQL
Posted by Kedar Vaijanapurkar on Mon 23 Mar 2015 06:27 UTC
Tags:

Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.

The post How to fix definer does not exist error 1449 MySQL first appeared on Change Is Inevitable.

Jan
30
2012
Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY
Posted by Kedar Vaijanapurkar on Mon 30 Jan 2012 16:29 UTC
Tags:

MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…

The post Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY first appeared on Change Is Inevitable.

Dec
29
2009
Filtering mysqldump output
Posted by Giuseppe Maxia on Tue 29 Dec 2009 13:16 UTC
Tags:



Several people have suggested a more flexible approach at mysqldump output in matter of user privileges.
When you dump the data structure for views, triggers, and stored routines, you also dump the permissions related to such objects, with the DEFINER clause.
It would be nice to have such DEFINER clauses removed, or even replaced with the appropriate users in the new database.


The mysqldump filter was created with this need in mind. It allows you to remove all DEFINER clauses and eventually replacing them with a better one.
For example:


mysqldump --no-data sakila | dump_filter --delete > …
[Read more]
Showing entries 1 to 3