SAP HANA Role

[Former Member]

Hi All need your help in implementing the below mentioned requirement in SAP HANA.

Business is requesting for the default values to be populated in variable screen based on the restriction assigned to that particular role.

For example, if a role is restricted with Region XXX, when the user executes the view then XXX value must be populated as a default value for RegionCode variable in the selection screen prompt.

Can any one suggest please.

[kapil_tilwani]

Hi,

You could query the "Structured_Privileges" view and obtain the details of the value granted to the user (Operand) field along with operator information as well (EQUAL/IN).

However, this is easier said than done if you have multiple values, multiple roles attached.  Also, you do have to ensure that the name of the structured privilege follows a consistent pattern in line with the view name.

Hope this helps !

Regards,

Kapil