list_sql_permissions
List T-SQL database permissions from sys.database_permissions, with optional filters by principal, schema, or object. Identify who has access to databases, schemas, and objects.
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 |