authorizations trace in SAP HANA

[Former Member]

Hello,

I'm looking for a tool in SAP HANA to know which authoriztaions are missing. Something like ST01 or SU53 in the ECC,

Is there something like it in SAP HANA? How do i know which authorization objects are missing for a user?

Thanks,

Amir

[rindia · Accepted solution]

Hi,

I guess there is no such equivalent but we can find what authorizations an USER has by querying the table "SYS"."GRANTED_PRIVILEGES" .

You can query by Object type,Schema Name, Grantee, etc.

In order to find privileges for a particular user, the query will be

select * from "SYS"."GRANTED_PRIVILEGES"

where GRANTEE = 'user_name'

Regards

Raj

[JK]

see

[lbreddemann]

Please don't resurrect age old threads.