SAP Knowledge Base Article - Preview

3216792 - Is there any super user in HANA with which you can assess to all schemas or objects

Symptom

You can find all schemas and objects available in HANA with following SQL:
SELECT * FROM SCHEMAS
SELECT * FROM OBJECTS


However,

  • you cannot find all those schemas in HANA studio even when you logged on as SYSTEM user.

  • following error would occur if you run a select on the object where you cannot find in HANA studio even when it does exist

Could not execute 'select * from "TESTSCHEMA"."TESTTABLE"'

SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '**************************'


Read more...

Environment

  • HANA 1.0
  • HANA 2.0

Product

SAP HANA, platform edition all versions

Keywords

supersure, not authorized, missing, lost , KBA , HAN-DB-SEC , SAP HANA Security & User Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.