Open SQL Data Browser error User is not authorized to read table

[SC]

Hi Experts,

we are on NW Portal 7.30 EHP1 SP5 and want to use the Open SQL Data Browser in NWA with the administrator user. Appropriate Roles and Actions as descriped in SAP Help were asigned.

But no matter what table we select in the screen, we always get the error "User is not authorized to read table <TABLENAME>"

We found SAP note 1748559  which exacly discribes that behavoir and of course we've implemented it.

Perhaps anybody can help me to get work with this tool.

Thanks a lot!

Christian

[Former Member]

Hi,

you can assign your ume action to any of your roles. There is no role explicit for the open sql data browser.

1. build and deploy a project of type ume permission

add the following code to your action.xml

<?xml version="1.0" encoding="UTF-8"?>

<BUSINESSSERVICE NAME=TablePermission">

  <DESCRIPTION LOCALE="de" VALUE="TablePermission" />

<ACTION NAME="TableReadAccess">

  <PERMISSION class="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="<your_tableprefix>_*" />

</ACTION>

</BUSINESSSERVICE>

2. Log in into the ume and select one role of your choice and you are member of.

    Press Modify and click on the action tab.

    Search for "TableReadAccess" and add this action to the selected role.

3. Finish.

Best Regards

[Former Member]

Hi Andre,

Can you tell me in detail steps how do i enable this? I am trying to use the Open SQL Data Browser but then i get the error. I dont know where we need to create the actions.xml file and where do i need to place them?

rgds

aditya

[Former Member]

Hi Aditya,

the ume actions are java development components.

To build them is pretty easy.

1. Creating Development Components for UME Actions
2. Modify the action.xml
3. deploy the component

You need a little bit basic knowledge of the developer studio.

the result looks like this

after deployment show in one role of your choice and you are member off.

Add the ume_action like this.

Best Regards

[junwu]

Hi Andre,

how u are able to deploy that ume dc?

it says missing permission class when i deploy my dc

Best regards,

Jun

[viktor_misurak]

Hi Jun,

please see my reply at http://scn.sap.com/thread/3469047

This should address your issue.

Best regards,

Viktor

[Former Member]

Exactly,

you have to write the xml elements uppercase.

Take a look in the deployment errorlog. You can find there one crucial error: "couldn't be deployed: Problem at parsing or deploying Actions XML file!"

Here is an example of the ume_action.xml

<?xml version="1.0" encoding="UTF-8"?>
<BUSINESSSERVICE NAME="YourServiceName">
  <DESCRIPTION LOCALE="de" VALUE="YourDescription" /> 
 <ACTION NAME="TableReadAccess">
 <PERMISSION class="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="Praefix_*" />
</ACTION>
   </BUSINESSSERVICE>

Best regards,

André

[junwu]

Hi Viktor,

thanks, that tricky works.

Best regards,

Jun

[DG]

Hi

I dont know if it is the same as theis help guide.

http://help.sap.com/saphelp_nw73/helpdata/en/49/f6cdafe45e088be10000000a421937/frameset.htm

Had had the same problem for some SAP PI tables and was able to find some roles I could add and then I got access to the table of interest.

Daniel

[former_member315656]

Hello Daniel,

I have the same problem.

Which roles do you have added, is there a documentation available?

Best Regards,

Wolfgang

[DG]

HI

I never found out how to use the roles. So I just created a web app to see the data i wanted.

daniel