How do you see what roles have been granted access to a particular schema in HANA Studio?

[Former Member]

How do you see what roles have been granted access to a particular schema in HANA Studio?

[former_member184768]

Hi Rosalynn,

Please refer to the view GRANTED_ROLES for the data you need. The details on the view are available at the link below.

You can select * from the view for GRANTEE = schema_name and GRANTEE_TYPE = 'USER';

http://help.sap.com/hana/html/_g_r_a_n_t_e_d__r_o_l_e_s.html

Regards,

Ravi