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
891
November 13, 2019 03:43AM


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.