SAP Knowledge Base Article - Preview

3017160 - several GRANT SQL statements in DBACOCKPIT shows incorrect syntax error

Symptom

When running the several GRANT SQL statements at once in DBACOCKPIT, it retruns the following error.

GRANT SELECT ON <OBJECT_NAME> TO <YOUR_USER_OR_ROLE>;

GRANT SELECT ON <OBJECT_NAME> TO <YOUR_USER_OR_ROLE>;

Error: sql syntax error: incorrect syntax near "GRANT": line 1 col 42 (at pos 42)


Read more...

Environment

HANA 1.0

HANA 2.0

Product

SAP HANA, platform edition all versions

Keywords

"multiple statements", "several statements" , KBA , HAN-DB , SAP HANA Database , Problem

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.