List effective privileges
hana_list_privilegesCheck effective privileges for a database user or yourself by querying SYS.EFFECTIVE_PRIVILEGES to verify access rights.
Instructions
List effective privileges for a user (or CURRENT_USER if omitted) from SYS.EFFECTIVE_PRIVILEGES. Requires CATALOG READ privilege or querying own privileges.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| grantee | No | Database user to query. Omit for current user. |