SAP Knowledge Base Article - Preview

2816157 - Limiting the users that have permission to check database object definition. - SAP IQ

Symptom

  • Database is organized in separate schemas and different users are given access to objects in different schemas.

  • The role PUBLIC provides this system wide privilege to see all database object definitions. If we revoke that privilege users cannot browse any database object definitions at all and will not be able to access the schema for the objects they are authorized to query.

  • You would like to limit the users that have permission to check database object definition. Hence, not all users will be able to see every database objects that exist outside the database schema they have access to, nor being able to see the table structure.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 15.4 

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

PUBLIC revoke schema privilege access database object definition feature request 819705 CR819705 CR#819705 , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.