dbeaver / dbeaver/dbeaver

DB2 for z/OS and LUW - Missing (object) privileges at schema properties view

Open
#8,590 1 comment 0 reactions 0 assignees View on GitHub
x:db2 x:db2i xf:metadata
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):

![image](https://user-images.githubusercontent.com/61581747/80705912-a182be00-8ae7-11ea-810e-7b42aa3e9688.png)

**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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.