Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Permissions needed for WebServices Methods

Received Response
21
Views
4
Comments
deeps
deeps Rank 3 - Community Apprentice
edited Aug 13, 2024 7:05PM in Oracle Analytics Cloud and Server

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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

    Capture.PNG

    So the permissions required is this one:

    Capture1.PNG

  • deeps
    deeps Rank 3 - Community Apprentice

    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

  • Gianni Ceresa
    Gianni Ceresa Mod

    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....

  • deeps
    deeps Rank 3 - Community Apprentice

    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.