Forum Discussion
Helper IPermissions to execute stored procedure
I am trying to executive a stored procedure which executes another stored procedure to decrypt some data. I get the unecrypted data but all the encrpyted data is blank. I have made sure both SP's have the Execute permission using the account used in the Gateway credentials along with the service account the gateway service is running. And when the Scheduled Refresh happens there is no errors.
5 Replies
jeffprandallPermissions ran - top user is the service account, bottom user is a SQL Account used in Gateway Credentials (tests do pass)
v-henryk-mstfCommunity Support
Hi jeffprandall ,
You can refer to the related blogs and documents provided below, hoping to help you.
Always Encrypted - SQL Server | Microsoft Docs
Power BI and SQL Always Encrypted (linkedin.com)
If the problem is still not resolved, please provide detailed error information screenshoot and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- jeffprandall
The database itself is not encrypted just the data in the column. The stored procedure makes a OPEN SYMMETRIC KEY and DECRYPTION BY CERTIFICATE to unencrypt the data.
- v-henryk-mstf
Hi jeffprandall ,
Is your problem solved, do you need further help? Looking forward to your reply.
If the problem has been solved, you can mark the valuable reply as the correct answer to help the other members find it more quickly.
Best Regards,
Henry