SAP Knowledge Base Article - Preview

3491813 - SELECT permission denied on system tables - SAP ASE for Business Suite

Symptom

SM21 is reporting SQL10330] , and when checking details in developer trace file the SQL statement is showing a SELECT on an ASE "system" table, ie:

C  ERROR: -1 in function StartSelect (execute) [line 36344]
C  (10330) [42000] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SELECT permission denied on ob
C  ject syscolumns, database <SID>, owner dbo
C  
C  sql statement is ==> SELECT name, colid FROM "syscolumns"  WHERE id = OBJECT_ID( ? ) ORDER BY colid 
C  
C  /* R3:D:/depot/bas/753_REL/src/dbs/syb/dbddsyb:346 T:syscolumns M:000 */
C  
B  *** ERROR => dbdynpdb2: dbdd_dbtab_columns (DYNPLOAD) failed with SQL error
 [dbdynpdb2.c  2901]
B  {root-id=00155DF6F3501EDF8CD43B69D9060124}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BY4=> sql error 10330  performing SEL on table dbtab_cols [dbdynpdb     2902]
B  ***LOG BY0=> [ASE Error SQL10330:42000]SELECT permission denied on object syscolumns, database <SID>, owner dbo [dbdynpdb     2902] 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.x
  • SAP Netweaver - All versions

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

"permission denied", "system tables", SQL10330, 10330, permission, SWPM, grant, denied , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.