SAP Knowledge Base Article - Preview

3690137 - [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SELECT permission denied on object <objname> for SAP ASE for BS

Symptom

  • Trying to pull data from tables like MARA, MATDOC in SAP Business Suite system running on ASE database using PyODBC
  • The ASE ODBC driver included in SDK for ASE software is used
  • Test connection from ODBC driver failed with error:

    =====================================================

    Connecting to Sybase...

    Connection SUCCESS!

    Connection FAILED: ('42000', '[42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SELECT permission denied on object <objname>, database <SID>, owner SAPSR3\n (10330) (SQLExecDirectW)')

    ========================================================


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0

Keywords

SAP Sybase, ODBC driver, SDK for ASE, connection failure, SAPSR3 user, database access, Power BI , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-SDK , SDK , 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.