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, IQ, CREATE SCHEMA, SCHEMA, AUTHORIZATION , KBA , BC-SYB-IQ , Sybase IQ , 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.