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.
SAP Knowledge Base Article - Preview