SUPER privilege

Archived Topics
1

I have a refresh button of sorts on my PMI screen that executes an ALTER VIEW query. When I click on the button, I get the following Error

Gateway Error 301:
SQL error for “”: Access denied; you need the SUPER privilege for this operation

I would assume this has something to do with the root user’s privileges in the database but as far as I can tell that user can do whatever he wants.

Thanks

2

Error 301 means that that is the message coming directly from the database, so this has to be a database permissions problem.

  1. What kind of database is it and
  2. Double-check what username the FactoryPMI datasource is configured to use, maybe it’s not connecting as “root”