SAP Knowledge Base Article - Preview

2937020 - Non-DBA user cannot grant VIEW permissions properly - SAP IQ

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 

Product

SAP IQ all versions

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.