SAP Knowledge Base Article - Preview

3299294 - Error "No authorization for table/view xxx in schema SYS in database LOCAL." returned in DBACockpit

Symptom

When executing SQL statements provided via SAP Note 1969700 (e.g. HANA_SQL_StatementHash_DataCollector) in (DBAcockpit-->Diagnostics-->SQL Editor), below error is returned:

"No authorization for table/view RS_TABLES_ in schema SYS in database LOCAL."

Error above maye be occur when you run other select SQLs in SQL Editor.

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

No authorization, for table/view, RS_TABLES_, M_LANDSCAPE_HOST_CONFIGURATION, SYS, DBACockpit, SQL Editor , KBA , HAN-DB-ENG , SAP HANA DB Engines , 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.