SAP Hana read only system privileges

[Former Member]

Is there a SAP Hana database system privileges or roles that allow for read access to all tables/views? The closet one I can find is CATALOG READ which only allow reading catalog objects. I would like to create a user that can access all data in a given database. I see there is a DATABASE ADMIN system privileges at the container level. But that seem like database admin function without access to data as well.

Are there some system privileges or roles I can grants to make this happen?

Thank you very much for you help.

Regards,

Louis

[former_member183326]

"I would like to create a user that can access all data in a given database"

I'm guessing you want to know if there is a SYSTEM privilege that allows one user in a Multi tenant system to read all data across a landscape? The answer is definitely not, if you think about it, that would be a very very bad privilege to have at your disposal, it would be a huge security risk.

There is cross tenant querying which would help you achieve what you want