Sample Header Ad - 728x90

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