How to set or grant SELECTINAUTH for a schema in DB2 11.5
1
vote
1
answer
1426
views
I'm running DB2 11.5 and want to grant select, insert, update or delete rights for all tables in a specific schema. SELECTINAUTH etc. seems to be perfect for this.
When I'm looking to the SYSCAT.SCHEMAAUTH Catalog View I can see the following columns:
- ALTERINAUTH
- CREATEINAUTH
- DROPINAUTH
- SELECTINAUTH
- INSERTINAUTH
- UPDATEINAUTH
- DELETEINAUTH
The first 3 privileges can be granted by e.g. GRANT ALTERINAUTH ON SCHEMA TO USER . But this don't work for the last 4 columns.
The Knowledge Center tells that this are implicit privileges, but I can't find any hint, how a user or a group can get this privileges implicit or explicit.
Does anybody know when or how e.g. INYSERTINAUT is set to Y?
Asked by Cyberider
(69 rep)
Jul 28, 2020, 02:29 PM
Last activity: Aug 24, 2020, 01:21 PM
Last activity: Aug 24, 2020, 01:21 PM