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.
SAP Knowledge Base Article - Preview