Symptom
non-DBA user cannot grant VIEW permissions properly.
SELECT * FROM USER2.TEST_VIEW;
Could not execute statement.
Permission denied: you do not have permission to select from "TEST_VIEW"
SQLCODE=-121, ODBC 3 State="42000"
Line 1, column 1
Read more...
Environment
- SAP Sybase IQ 15.x
- SAP IQ 16.0
- SAP IQ 16.1
Keywords
grant, view, non-dba, dba, IQ, SAP IQ, 15.4, 16.0, 16.1, -121, 42000, permissions , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.