list_sql_permissions
List T-SQL database permissions by workspace and item, with optional filtering by principal, schema, or object name. Returns securables for database, schema, and object classes.
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 |