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 for Me (Login required).

Search for additional results

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