SAP Knowledge Base Article - Preview

2814549 - GRANT ALTER ANY OBJECT allows altering tables/objects owned by other users - SAP IQ

Symptom

In IQ 16 to alter any table/objets, we have to use:

GRANT EXECUTE ON sp_iqrename TO USER;
GRANT ALTER ANY OBJECT TO USER;

GRANT ALTER ANY OBJECT TO USER, (no only) allows altering objects owned by object owner but also allows altering tables/objects owned by others.


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR819669, CR#819669, 819669 , 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.