Skip to main content
K
katiel0001
October 2, 2023
Solved

SQL Compare and Deploy Error

  • October 2, 2023
  • 12 replies
  • 0 views

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?

Best answer by stefanhelzle0001

My gut feeling says: "Probably, let's try that first!"

I strictly keep definer clauses out of my SQL scripts and never had any issues.

12 replies

stefanhelzle0001
stefanhelzle0001
October 2, 2023

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.

K
katiel0001Author
October 3, 2023

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?

abhishekt1213
abhishekt1213
October 4, 2023

Hi there, I think they need super privileges in DB then only they can execute the script. 

K
katiel0001Author
October 4, 2023

Who needs super privilege? The person clicking on compare and deploy on the SQL package? And what part do they need super privilege on? Because the script has stored procedures or?

K
kyleh299
June 13, 2024

[mention:44f6aa0a3e5845f59072ee67d520a24b:e9ed411860ed4f2ba0265705b8793d05] Did you figure out the issue?

K
katiel0001Author
June 13, 2024

Yes, Stefan was correct

Terms & ConditionsAccessibility statement