MySQL Forums
Forum List  »  Views

View Security Permissions
Posted by: Andrew debeer
Date: December 09, 2020 02:30AM

When using MySQL Workbench the following code is automatically entered:
"ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER"

This is fine when using a locally installed server. But when running the server across a network it generates an error. How do I rectify this?

Best Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
View Security Permissions
89
December 09, 2020 02:30AM


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.