JDBC Driver for Veeva Vault

Build 22.0.8462

ObjectRoles

Manually retrieve assigned roles on an object record and the users and groups assigned to them.

View Specific Information

ObjectName and RecordId must be specified in order to query this view.
Note: In this provider vault objects are exposed as views. And the keys of these views corresponds to RecordId.
Some query examples:

SELECT * FROM ObjectRoles WHERE ObjectName = 'product__v' AND RecordId = '00P000000000201'
SELECT * FROM ObjectRoles WHERE ObjectName = 'activity__v' AND RecordId = '0AC000000001D27'

Columns

Name Type Description
RecordId [KEY] String Name of the role.
ObjectName [KEY] String Name of the role.
Name String Name of the role.
Users String Comma-separated list of user Ids.
Groups String Comma-separated list of group Ids.
AssignmentType String Type of the assignment.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462