NWA open SQL browser

[Former Member]

Hi Experts,

We have created custom tables on JAVA stack. And they are in SAP(SYSID)DB2 schema and the user SAP(SYSID)DB2 has the read only access to those tables,like other standard tables.

But these custom tables are not listed in SQL browser. We could see all the other standard tables listed there and we are able to access them.

Is there any thing that we need to do, for getting these custom tables listed in SQL browser. the owner for these custom tables is also same as other standard tables.

Please suggest.

Thanks,

Vijaya

[former_member184720]

Hi Vijaya -  Did you define the UME role to access the custom table and assigned the same to the user?

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

[Former Member]

Thanks for the reply Hareesh.

We haven't gone to accessing the tables yet, we are struck at custom tables not listed in SQL browser.

Do we need to define UME role to get the custom tables listed in browser?

Thanks,

Vijaya