DB2 for z/OS and LUW - Missing (object) privileges at schema properties view
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
**Is your feature request related to a problem? Please describe.**
DBeaver does not show (object) privileges information for DB2 for z/OS and DB2 for LUW objects. For other RDBMS for instance Oracle that information is present (see tab Privileges):

**Describe the solution you'd like**
Please provide privilege information also for DB2 for z/OS and DB2 for LUW objects by querying the system catalog. For instance using following query (DB2 for z/OS):
```
SELECT GRANTEE
, CASE
WHEN GRANTEETYPE = '' THEN 'AUTHORIZATION ID'
WHEN GRANTEETYPE = 'L' THEN 'ROLE'
ELSE 'PACKAGE/PLAN'
END AS "TYPE"
, GRANTOR
, SELECTAUTH AS "SELECT"
, INSERTAUTH AS "INSERT"
, UPDATEAUTH AS "UPDATE"
, DELETEAUTH AS "DELETE"
, ALTERAUTH AS "ALTER"
, REFERENCESAUTH AS "REFERENCE"
, INDEXAUTH AS "INDEX"
, TRIGGERAUTH AS "TRIGGER"
FROM SYSIBM.SYSTABAUTH
WHERE TCREATOR =
AND TTNAME =
```
**Additional context**
System information:
- Windows 10 Pro
- DBeaver CE - Version 7.0.2.202004051509
- Database DB2 for z/OS V12 and DB2 for LUW V11.1
Contributor guide
Assessment
This issue has not been assessed yet.