SAP Knowledge Base Article - Preview

1904386 - SYBASE IQ : Permission Denied: You do not have permission to select from B.VW

Symptom

"C" user has all necessary authorities in order to access a view(B.vw).
 But when "C" user tries to access view(B.vw), "C" is getting a permission error like below.

  [Error]
  “Permission Denied: You do not have permission to select from B.VW”

Here are situations:

 There are 3 users(A,B,C).
 
 1) A has a resource authority.
     And A has two tables(“A.T1“, “A.T2“).
 2) B has a resource authority.
     B has a view(B.vw) which uses two tables(“A.T1“, “A.T2“).
     And B has a select authority about two tables.
 3) C has a select authority about view(B.vw).
     But when C tries to access a B.vw, A permission error is returned even though C has all authorities about related objects(A.T1, A.T2,B.vw).


Read more...

Environment

  • SYBASE IQ 12.7
  • SYBASE IQ 15.2
  • SYBASE IQ 15.4
  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

permissions on views, with grant option, underlying table, IQ, SAP IQ, permission, grant, table , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.