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.