who_can_access
Every user who has privileges on a database (or one table in it), and how they got them.
Instructions
Every user who has privileges on a database (or one table in it), and how they got them.
"How" is "direct" (granted to the user), "via role R ← group G" (user -> group -> role), on the database /
table itself or globally on *.*. Administrative global privileges that don't open data (CREATE USER,
PROCESS, ...) and USAGE are left out. Read-only. Opens the Security view on this lookup.
Args:
database: Database name (exact).
table: Optional table in that database.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | ||
| database | Yes |