list_sql_permissions
List database permissions from sys.database_permissions with optional filters for principal, schema, or object. Returns DATABASE, SCHEMA, and OBJECT class securables.
Instructions
List T-SQL database permissions from sys.database_permissions.
Reads from sys.database_permissions joined to sys.database_principals. Returns DATABASE, SCHEMA, and OBJECT class securables with readable names.
Args:
workspace: Workspace name or GUID.
item: Warehouse or SQL endpoint name or GUID.
principal: Filter by principal name (optional).
schema: Filter by schema name -- returns SCHEMA class rows for this
schema (optional).
object_name: Filter by qualified object name <schema>.<object>
-- returns OBJECT class rows for this object (optional).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| item | Yes | ||
| schema | No | ||
| principal | No | ||
| workspace | Yes | ||
| object_name | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |