JMS Related tables in PI Single Stack

[rasjoshi]

Hi All,

How can we check tables in SAP PI Single stack

for e.g. --> XI_AF_SVC_ID_MAP

BR,

Rashmi

[justin_santhanam]

Hi Rashmi,

I haven't done this, but seems this is the way to do it... I'm not sure though.

See the SAP Note:

2168962 - Authorization issue in SQL data browser

Resolution

1. Create an action with NetWeaver Development Studio with following content:
   
   <ACTION NAME="MyAction">
           <PERMISSION class="com.sap.sql.itsam.databrowser.permission.DataBrowserPermission" NAME="ReadTables" VALUE="MyTable" />
   </ACTION>
2. Deploy the action to the Java server
3. Assign the action to a role or user.

Thanks!

[justin_santhanam]

Hi Rashmi,

Did you try the below one?

NWA --> Troubleshooting -->Database -->Open SQL Data Browser

Thanks,

Justin.

[rasjoshi]

I am getting permission not suffice error here... What role required to access data here?

BR,

Rashmi

[former_member186851]

Assing this role -NWA_SuperADMIN and assingn UME action to the access the desired table.

Using Open SQL Data Browser - SAP NetWeaver Administrator - SAP Library