Skip to Content
author's profile photo Former Member
Former Member

SAP Hana read only system privileges

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jan 02, 2018 at 09:00 PM

    "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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.