- 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
About this pageThis 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.