MySQL Forums
Forum List  »  InnoDB

Fall back to error 1216/1217 without a lot of ddl user rights
Posted by: Nico Schoemaker
Date: November 13, 2019 03:43AM

Hi,

I noticed that if a database user doesn't have a lot of DDL rights innodb falls back to error 1216/1217 instead of using error 1451/1452. My client code relies on the more descriptive error messages included in error 1451/1452.
To get the 1451/1452 error message's a user must have the following DDL rights:

-CREATE
-ALTER
-REFERENCES
-INDEX
-CREATE VIEW
-DROP
-TRIGGER

Since i would like to have no or a minimum of DDL rights assigned to the user, my question is if there is a way to get the 1451/1452 error messages?

TIA!

Options: ReplyQuote


Subject
Views
Written By
Posted
Fall back to error 1216/1217 without a lot of ddl user rights
68
November 13, 2019 03:43AM


Sorry, only registered users may post in this forum.

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.