roles
Description
Exposes metadata about roles defined in the organization. Only roles on which the current role has USAGE privileges are returned. The granted_to and granted_roles fields are JSON arrays showing the role hierarchy.
Syntax
SELECT * FROM deltastream.sys."roles";Columns
name
VARCHAR
No
Name of the role.
owner
VARCHAR
No
The role that owns this resource.
granted_to
VARCHAR
Yes
JSON array of role names this role has been granted to.
granted_roles
VARCHAR
Yes
JSON array of role names that have been granted to this role.
member_count
INTEGER
No
Number of users who are members of this role.
created_by_role
VARCHAR
No
The role that created this resource.
created_by_role_deleted
BOOLEAN
No
Whether the creating role has since been deleted.
created_by
VARCHAR
No
The user that created this resource.
created_at
TIMESTAMP_LTZ
No
Timestamp when this resource was created.
updated_by_role
VARCHAR
No
The role that last updated this resource.
updated_by_role_deleted
BOOLEAN
No
Whether the last updating role has since been deleted.
updated_by
VARCHAR
No
The user that last updated this resource.
updated_at
TIMESTAMP_LTZ
No
Timestamp when this resource was last updated.
organization_id
VARCHAR
No
The unique identifier of the organization this resource belongs to.
Examples
List all roles:
See Also
Last updated