Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Permissions needed for WebServices Methods
Hi Gurus, I am trying to use getSessionVariable() Method to retrieve a list of session variables from RPD and display on UI. As configured in SampleApp, I have used "listRepVars.js" java script.
What permissions are needed for an user to display these? Repository variables works with BI Administrator, but not with other users. Unable to display Sessions Variables with any user.
Answers
-
Hi,
listRepVars.js in SampleApp doesn't really use a webservice ....
It contains this:
xhttp.open("POST", "saw.dll?IssueRawSQL", false);This is the Issue SQL page in the Administration.

So the permissions required is this one:
0 -
Hi Gianni, Thanks for prompt response. I have seen that issueRawSQL, gave permissions to my user and executed the script, but it didn't work. I have observed that the results are displayed only for "BI Administrator". Can you please help me where else the permissions need to be setup to execute this javascript by normal user in another group?
thanks,
Pradeep
0 -
If as a normal user you try to access saw.dll?IssueRawSQL directly in your browser does it works?
Maybe you also need to give access to the admin page to allow the user to see that page....
0 -
My catalog seems to be corrupted with permissions.
Call SAPurgeAllCache() used to work in the past and it doesn't work now. call NQSQueryMetadataObjects('3031') should have same permissions too.
Thanks Gianni. I will check on fixing the permissions first.
0
