I have some basic questions, I could not find the commands for it:
1. With what command can I check which privileges I have regarding a database?
2. I would like to create a view in a schema, let`s say in schema "db2inst1". But I know that all of other users can also access this schema. How can I make sure, that the view I create, can only be seen by me?
Thank you for your helps.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-06-24T19:26:38Z by SystemAdmin
Pinned topic create schema
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-24T19:26:38Z at 2012-06-24T19:26:38Z by SystemAdmin
SystemAdmin 110000D4XK5837 PostsACCEPTED ANSWER
Re: create schema2012-06-24T19:26:38Z in response to RatnaleinHello Ratna,
The authorisations are stored in the catalog. For examples the list of roles is stored in SYSCAT.ROLES, the users granted roles in SYSCAT.ROLEAUTH, database authorities in SYSCAT.DBAUTH, tables privileges in SYSCAT.TABAUTH etc etc.
By default, these catalog views are readable by PUBLIC, but you may revoke this.
Hope this helps.