Open SQL Data Browser - Create UME action

[Former Member]

Hello All,

We need to create UME action to be able to read the contents of a few tables via Open SQL Data Browser.

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

http://help.sap.com/saphelp_nw73/helpdata/en/19/ef7b48be524ceaac80f6ee1736eb94/frameset.htm

The prerequisites for creating UME Actions are:

•You have added code for permission checks to your application.

•You have created a permission class to protect your application.

•You have created a development component of the type UME Permissions.

Is this to be done by development team or security team?

Thanks.

Best Regards,

Anita

[Former Member]

Hello All,

If someone has any idea, kindly revert as to which team should be held responsible for this task.

Thanks.

Best Regards,

Anita

[s_yuksektepe]

I Got stuck in creating UME actions for the desired tables, so I found sapnote 1898072:

download the "bc~jms~permission~app.ear" file from sapnote: 1898072 - User not authorized to read JMS tables data in SQL browser.

place the file:

/usr/sap/<SID>/J<NR>/j2ee/deployment/scripts/

./deploy.csh <java_admin>:<password>@<sap_j2ee_server>:5<instance_number>04 bc~jms~permission~app.ear version_rule=all

After the deployment, the role NWA_SUPERADMIN allows the action BC_JMS_ReadAction. You can double-check this using the IdentityManagement.

You can also further assign the role NWA_SUPERADMIN to specific users or groups by using the IdentityManagement.

[Former Member]

Hello S. Yuksektepe,

Thanks. I wanted to be able to read the following tables:

- BC_SL_PRDVERS

- BC_SL_SWFEATURE

- BC_SL_SWFEATUREINC

I think the Note is only for JMS tables.

Best Regards,

Anita