Viewing Data in Java Tables - PI 7.31 SP06

[former_member187739]

Hello All,

I am trying to view the data in the below tables on the Java Stack through NWA . But I am getting "User is not authorized to read table XI_AF_LMS_EXTRACTR.".

We are running PI 7.31 SP06, dual installation..I have searched a few blogs, but none of them had a solution for this.

Navigation to these tables: Log on to NWA ->Troubleshooting->Database->OpenSQLDataBrowser

XI_AF_LMS_EXTRACTR

XI_AF_LMS_FILTER

XI_AF_LMS_DATA

Our Security person gave permissions to all the java roles and i was given all the roles as PISUPER, but still I am not authorized to read the table.

I checked the security logs in NWA, it shows

Permission check failed | ACCESS.ERROR | null | | Permission=[(com.sap.sql.itsam.databrowser.permission.DataBrowserPermission ReadTables XI_AF_LMS_EXTRACTR)]

Could you please tell us what permissions are we missing???

Thanks,

Harsh

[Reagan]

Hello

Check the last suggestion in this thread.

http://scn.sap.com/thread/3303045

Regards

RB

[former_member187739]

Thanks Benjamin, We are able to access the tables with j2ee_admin user.

Thanks,

Harsh