Symptom
In SAP IQ, it is possible to create schema with sql command
CREATE SCHEMA AUTHORIZATION <userid> ... [ { <create-table-statement> | <create-view-statement> | <grant-statement> } ]
Example:
CREATE SCHEMA AUTHORIZATION User_A
CREATE TABLE test_A1 ( id1 INT PRIMARY KEY )
CREATE TABLE test_A2 ( id2 INT PRIMARY KEY )
GRANT select on test_A1 to User_B
GRANT select on test_A2 to User_B
Question:
What is the command or system table which allows to find Schema created using command above ?
Read more...
Environment
- SAP IQ 16.1
- SAP IQ 16.0
- SAP IQ 15.x
Product
Keywords
Sybase , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
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.
SAP Knowledge Base Article - Preview