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

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

• SAP IQ 16.0
• SAP IQ 15.4 

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