How to Preview data of SAP HANA View as other user ?

[-Charlie-]

Hi experts,

In SAP HANA, for example,  there are users A001 and B001.

The password of A001 is unkown.

Log on the SAP HANA system with user A001 and I want to preview data of SAP HANA Views with authority of  B001.

How to achieve this ? 

Tks.

[eason_chen]

Hi,
You may try to grant the same privileges as A001 to B001.

To achieve this, you may use following SQL attached in note 1969700. It will generate a list SQLs for you to grant the same privileges and roles to B001.

SQL:HANA_Security_CopyPrivilegesAndRoles_CommandGenerator (SOURCE_GRANTEE = 'A001', TARGET_GRANTEE = 'B001')

PS: Parameters suggested above need to be adapted in /* Modification section */ of corresponding SQLs. Detailed information about how to change parameters in /* Modification section */ can be referred to note 1969700.

Please be aware that you still need use a DB user who has sufficient privilege to grant those roles and privileges to B001.

Best Regards,
Eason Chen

[HakanHaslaman]

It is not supported to preview data as another user unless you log on with that user. HANA SQL and data preview always run with the effective session user.