Skip to Content
0

SAP Hana read only system privileges

Jan 02 at 07:19 PM

70

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Healy
Jan 02 at 09:00 PM
0

"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

Share
10 |10000 characters needed characters left characters exceeded