SAP Knowledge Base Article - Preview

2192708 - Permission denied error when running a statement

Symptom

  • You see error:

Could not execute statement.
Permission denied: you do not have permission <operation> <table>
SQLCODE=-121, ODBC 3 State="42000"
Line x, column x

1.png

  • The screenshot above shows an example of you not having permission to perform INSERT INTO operation to table "web_bool_fav_lineitem"


Read more...

Environment

  • Any supported versions of SAP SQL Anywhere
  • Any supported versions of SAP Sybase SQL Anywhere

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

granted, allowed, permissions, deny, executed, asa, anyhwere, role, roles, GRANT, privilege, privileges , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

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

Search for additional results

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