Zen Report - ErrorNo: 5540

Question

Question

Rui Figueiredo · Aug 25, 2017

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

John Murray · Aug 30, 2017

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:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... (in particular, the subsection titled "Modifying a User’s SQL-Related Options")

1 0

score 1 · Answer 1 · 2017-08-25T05:46:25-04:00

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

score 0 · Answer 2 · 2017-08-30T08:51:43-04:00

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

score 0 · Answer 3 · 2017-08-30T11:02:41-04:00

Benjamin Bryans · Aug 30, 2017

Hi John,

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

Kind regards,

Ben

0 0