Returns the permissions granted to roles within an organization. Specify RoleId to query one role, or omit it to source role ids from ComplianceRoles automatically. When OrganizationUuid is omitted, the provider uses the connection property or the first organization returned by Organizations.

View-Specific Information

Select

When RoleId is omitted, the driver obtains role Ids from ComplianceRoles and issues one permissions request for each role automatically. An explicit OrganizationUuid is also applied while sourcing the roles. When OrganizationUuid is omitted, the driver uses the OrganizationUUID connection property or the first row returned by Organizations.

The driver uses the Claude Compliance API to process WHERE clause conditions built with the following columns and operators server-side. The rest of the filter, including sorting, grouping, and offsets, is processed client-side within the driver.

• RoleId and OrganizationUuid using =
• LIMIT

	SELECT Action FROM ComplianceRolesPermissions WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' AND RoleId = 'role_123' LIMIT 100;
	SELECT RoleId, Action FROM ComplianceRolesPermissions WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' LIMIT 100;

Columns