Read data on the authorization action assignments for the organizations in which you are a member.

Table-specific Information

Note: Requires the rw_organization_admin OAuth scope.

Select

The AuthorizationAction column must be specified in the criteria to read data from this view. The = and IN operators are fully supported server-side for this column. Refer to the query examples below:

SELECT * FROM OrganizationAuthorizationActions WHERE AuthorizationAction = 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)'
SELECT * FROM OrganizationAuthorizationActions WHERE AuthorizationAction IN ('organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)', 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_WRITE)')

The values to use for the AuthorizationAction column must be exactly in the following format:

{ACTION}:(actionType:{TYPE})

Additionally, the casing used for these values matters. The {ACTION} part must be in camel case (for example: 'organizationRoleAuthorizationAction') and the {TYPE} part must be in screaming snake case (for example: 'ADMINISTRATOR_READ'). Refer to LinkedIn's API documentation for the values to use for the {ACTION} and {TYPE} placeholders.

The = operator is fully supported server-side for the OrganizationURN and MemberURN columns (composite key). The IN operator is partially supported server-side. Refer to the query examples below:

SELECT * FROM OrganizationAuthorizationActions WHERE (OrganizationURN, MemberURN) = ('urn:li:organization:4975021', 'urn:li:person:XXXXXXXXXX') AND AuthorizationAction = 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)'
SELECT * FROM OrganizationAuthorizationActions WHERE (OrganizationURN, MemberURN) IN (('urn:li:organization:4975021', 'urn:li:person:XXXXXXXXXX'), ('urn:li:organization:6554901', 'urn:li:person:YYYYYYYYYY')) AND AuthorizationAction IN ('organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)', 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_WRITE)')

When the OrganizationURN and MemberURN columns are not specified in the criteria as in the example below:

SELECT * FROM OrganizationAuthorizationActions WHERE AuthorizationAction = 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)'

, we internally post-process the query to the following before executing:

SELECT * FROM OrganizationAuthorizationActions WHERE (OrganizationURN, MemberURN) IN (SELECT Id, RoleAssignee FROM CompanyList WHERE State='APPROVED' AND Role='ADMINISTRATOR') AND AuthorizationAction = 'organizationRoleAuthorizationAction:(actionType:ADMINISTRATOR_READ)'

Columns

Name	Type	References	Description
OrganizationURN [KEY]	String		Unique identifier of the organization.
MemberURN [KEY]	String		Unique profile identifier of the member assigned the authorization action.
AuthorizationAction [KEY]	String		Authorization action assigned to the member for organization management.
Status	String		Status of the authorization action assignment.