How to get SQL Tables privileges

Question

Question

Kurt Hofman · Dec 1, 2020

#Security #Caché

Hello,

In Caché Management Portal yo can see the SQL privileges per table.

For example : http://localhost:57772/csp/sys/sec/%25CSP.UI.Portal.User.zen?PID=P#3 (Page "SQL Tables").

Is it possible to get them by objectscript or SQL ?

Regards.

Product version: Caché 2018.1

Discussion (2)1

Log in or sign up to continue

Robert Cemper · Dec 1, 2020

These classes may service your need:

0 0

score 0 · Answer 1 · 2020-12-01T11:08:28-05:00

I believe that I can achieve this via code, because, particularly, I find the web interface for accessing data very bad. There is also the possibility of using a local platform for this, which I believe is much better. DBeaver for example.