We are trying to deploy SQL scripts through Appian's compare and deploy, but we ran into this error: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation
The user who requested this package to be deployed has system admin permissions in the target environment, and I'm 99% sure they have system admin permissions in the source environment too. They weren't the ones who built the package itself though, but I'm not too sure if that matters here?
Does anyone know what this error is referring to?
Discussion posts and replies are publicly visible
I think this has nothing to do with that user's account is admin type or not. When you manage separate schemas in MariaDB, you need to be careful with creating objects using SQL scripts. The script generated by PHPMyAdmin include a user name, that can lead to issues when trying to run these scripts, as the created objects belongs to another user than the one used to connect from Appian to the DB.
We don't have separate schemas, and the scripts we generated did not include a username. We did have a create stored procedure in the scripts we were deploying. Do you think those could have caused an issue?