SAP Knowledge Base Article - Preview

3617578 - User without GRANT OPTION is wrongly allowed to grant privilege to another user - SAP IQ

Symptom

  1. Create a table
  2. Create a user usr_grantor
  3. Create a user usr_grantee
  4. Grant SELECT permission to user usr_grantor without GRANT OPTION (user usr_grantor cannot grant the same privilege to the other users)
  5. On SAP IQ 16.1, when user usr_grantor grants the SELECT permission to user usr_grantee, no error is fired and the user usr_grantee can select the table


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

830826, CR#830826, CR 830826, "WITH GRANT OPTION", Object-Level Privilege, , KBA , BC-SYB-IQ , Sybase IQ , Known Error

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.