adm_document_shares_v

Direct document shares, one row per explicit grant on a single document, with the recipient user or group name resolved. This is not effective access. Ownership, group ownership, a share inherited from a folder and the administrator bypass leave no row here.

Overview

Group: Administrative reporting

Category: Sharing - Access control and sharing analysis

Use Cases

List who a document was shared with directly
Audit explicit grants on single documents

Columns

The view contains 11 columns providing comprehensive information:

Column Name	Description
`doc_share_id`	Primary key of the share.
`document_id`	The shared document.
`shared_with_user_id`	Recipient user, when the share is with a user. Null for a group share.
`shared_with_group_id`	Recipient group, when the share is with a group. Null for a user share.
`share_role`	Rights the share grants on the document.
`created_date`	Timestamp the share was created.
`created_by`	User who created the share.
`updated_date`	Timestamp the share was last changed.
`updated_by`	User who last changed the share.
`username`	Username of the recipient user. Null for a group share.
`group_name`	Name of the recipient group. Null for a user share.

Description: Direct document shares, one row per explicit grant on a single document, with the recipient user or group name resolved. NOT effective access: ownership, group ownership, a share inherited from an ancestor folder and the administrator bypass all grant access without leaving a row here, and a row here is not usable if the document is trashed or archived. Use adm_access_control_api to ask whether a user can reach a document, and adm_my_documents_v to list what the current session can reach.

Key Features

Recipient user or group name resolved
Direct grants only: no ownership, no inherited folder shares, no administrator bypass
Does not check that the document is still reachable (trash, archive)