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
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.