adm_folder_shares_v

Direct folder shares, one row per explicit grant on a single folder, with the recipient user or group name resolved. This is not effective access. A share on a folder reaches every folder and document below it without a row of their own.

Overview

Group: Administrative reporting

Category: Sharing - Access control and sharing analysis

Use Cases

List who a folder was shared with directly
Audit explicit grants on folders

Columns

The view contains 11 columns providing comprehensive information:

Column Name	Description
`folder_share_id`	Primary key of the share.
`folder_id`	The shared folder. The grant reaches everything below it as well.
`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 folder and its subtree.
`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 folder shares, one row per explicit grant on a single folder, with the recipient user or group name resolved. NOT effective access: a share here also reaches every folder and document below the shared folder without leaving a row for them, and ownership, group ownership and the administrator bypass grant access without leaving a row at all. Use adm_access_control_api to ask whether a user can reach a folder, and adm_my_folders_v to list what the current session can reach.

Key Features

Recipient user or group name resolved
Direct grants only: a subtree share shows at the one folder it was created on
No ownership, group ownership or administrator bypass