Updating Grants after Table Rename
Posted by:
Dan Kelly
Date: September 18, 2013 03:17AM
We're in the process of tidying up our production database, and in the process need to rename a number of tables.
Am I right that when I rename a table, the GRANTS on the table are not updated to point to the new table name? That is what appears to be the case when looking at the information_schema.table_privileges table.
If so is there an easy way to move the grants across to the new table name?
If not what am I missing?
MySQL Server version is 5.0
Edited 1 time(s). Last edit at 09/18/2013 03:22AM by Dan Kelly.
Subject
Written By
Posted
Updating Grants after Table Rename
September 18, 2013 03:17AM
September 18, 2013 11:17AM
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.