0
510
Question Rui Figueiredo · Aug 25, 2017

Zen Report - ErrorNo: 5540

#Caché #ZEN

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

 

Regards,

Rui

Discussion (4)0
Log in or sign up to continue

Comments

Dmitry Maslennikov · Aug 25, 2017

Looks like, you have configured some security settings. And you forgot to give permissions to the new class for user.

0
Benjamin Bryans  Aug 30, 2017 to Dmitry Maslennikov

Can you advise where the security settings are found in Ensemble, so that we can see/give permissions?

0
John Murray  Aug 30, 2017 to Benjamin Bryans

Setups are managed in the Security subsection of the System Administration section of Portal.

Key documentation is at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

Parts specifically relevant to SQL access to data include:

0
Benjamin Bryans  Aug 30, 2017 to John Murray

Hi John,

Thanks for that, was just what I was looking for!

Kind regards,

Ben

0