SAP Knowledge Base Article - Preview

2561367 - Permission lost on 3 system views after upgrade to IQ16 SP11 PL12 - SAP IQ


  • On version IQ 16 SP 10.x, grant select permission to a user A on the system views: SYSUSERPERM, SYSUSERAUTH, SYSLOGINMAP.
  • Upgrade to IQ 16 SP 11 PL 12, and run "alter database upgrade".
  • When user A connects the upgraded database, and run a select on the 3 views, the error:

Permission denied: you do not have permission to select from view_name.



SAP IQ 16 SP 11 PL 12


SAP IQ 16.0


CR#811776 ; CR811776;  811776 ; SYSLOGINMAP ; SYSUSERAUTH  ; SYSUSERPERM ; permissions ; privilege ; , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.