Query and update the access control level for an opportunity.

Table Specific Information

Select

• OpportunityId supports the '=' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM OpportunityAccessControl WHERE OpportunityId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

SELECT * FROM OpportunityAccessControl

Update

Any column where ReadOnly=False can be updated. Specify the OpportunityId when updating an opportunity access control record.

UPDATE OpportunityAccessControl SET Type = 'Private' WHERE OpportunityId = '5d940c2d-e09e-4204-ad0a-375f73a550a7'

Columns

Name	Type	ReadOnly	Description
OpportunityId [KEY]	String	True	The unique identifier for the opportunity.
Type	String	False	Defines the opportunity's access level. The allowed values are Public, Private, LimitedAccess.
AccessorsAggregate	String	False	The users or teams that have been granted limited access to the opportunity.