Hey folks,
Been running into an odd situation. Although I am in the groups Database Administrators and Database Editors, I am unable to view or edit (most) Stored Procedures & Functions on the MariaDB. The Appian version the customer runs is 22.2 and I should have all the necessary privileges, but nope.. tried to search for a fix for this but alas, no answer could be found. Has anyone else have had this issue or know how to fix this?
Thanks in advance,
Matthias
Discussion posts and replies are publicly visible
What kind of error do you see?
The "edit" button is greyed out and I also cannot click it. I tried to select it from the list and manually "export" to see if I can somehow view it offline, but it says I lack privileges. Do you know of any other place where this is configured?
Do you use a separate schema in the DB?
Nope, should be in the normal Appian scheme.
Open a support case. Stored procedures established using the legacy "DEFINER=" value will need to be changed over manually in the back-end, and the symptoms you describe are what happens before this update is done. If you have the original stored procedure definition scripts handy (or you can get to them by some way other than the "edit" button), you can re-run them (i think with the "DEFINER=..." statement removed from the CREATE PROCEDURE statement) and that would correct that particular procedure - but of course this would need to be done manually for all of them, which can be a big pain (if even possible).
In your support case, mention older support case #557828.
Thank you for your reply and the explanation, Mike. I cannot interact with the SPs in any way (not even export them), so we opened a support case.