Hi There
We have installed JIWA on azure and database via a bacpac File.
Now we are trying to map Jiwa users with proper mapping and permissions, but since azure database limits us using management tools, we used sql scripts like below but it comes with you don’t have permission error. Pls let me know if there are any special instructions to setup Jiwa with azure database. Currently running a VM with Windows server 2019.
ALTER ROLE dbmanager ADD MEMBER [JiwaLogin];
ALTER ROLE loginmanager ADD MEMBER [JiwaLogin];