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