Online Tutorials & Training Materials | STechies.com
Register Login

What is the effect of the CATALOG READ privilege?

Chandan Singh Parihar || 23 Apr 2015 4:15 pm || 1

What is the effect of the CATALOG READ privilege?


Comments

  • 16 Jun 2015 1:54 pm Best Answer

    CATALOG READ controls to what extent a user can access data in SAP HANA dictionary tables (e.g. TABLE_COLUMNS or INDEXES). If CATALOG READ is granted, all information is visible. If CATALOG READ isn't granted, only the information for own objects is shown. At the same time the performance of these dictionary queries can be worse due to the required security checks.

    Unlike on other databases a missing CATALOG READ right doesn't result in an error, it just restricts the result set of dictionary queries.