查询Adobe Connect数据库中会议房间权限对应的表与字段

Hey there! I’ve spent a fair bit of time working with Adobe Connect’s backend schema, so I can break down exactly how those 4 meeting access options from the new meeting wizard map to the underlying database tables and fields. Let’s dive in:

First, a quick foundational note: All Adobe Connect meetings (rooms) are stored as SCOs (Sharable Content Objects) in the sco table. Access permissions are controlled via a mix of flags in this table and entries in the principal_permissions table, which handles granular access assignments.

1. Invited Only (Only people I invite can enter) #

• Key Table/Field: sco.is_public = 0 (marks the room as private)
• Access Control: Entry to the room is restricted exclusively to users/groups with a row in the principal_permissions table where:
  • principal_permissions.sco_id matches the meeting's unique sco.sco_id
  • principal_permissions.permission_id = 2 (this is the "view" permission required to enter the room)
  • Only invited users will have these entries—no broad access principals are present here.

2. Authenticated Users (Any Adobe Connect user can enter) #

• Key Table/Field: sco.is_public = 0
• Access Control: A special system-level permission entry exists in principal_permissions for all authenticated users:
  • principal_permissions.principal_id = -2 (this is the built-in ID for all users with valid Adobe Connect credentials)
  • principal_permissions.sco_id matches the meeting's sco.sco_id
  • principal_permissions.permission_id = 2

3. Public (Anyone with the URL can enter, no login required) #

• Key Table/Field: sco.is_public = 1
• Note: This flag directly enables open access to unauthenticated users. You don’t need any additional entries in principal_permissions for public access, though you can still add specific user permissions if you want to restrict certain actions for public visitors.

4. My Company/Enterprise (Only users in my company can enter) #

• Key Table/Field: sco.is_public = 0
• Access Control: A system-level permission entry exists in principal_permissions for all enterprise users:
  • principal_permissions.principal_id = -3 (the built-in ID for all users within your Adobe Connect enterprise/company instance)
  • principal_permissions.sco_id matches the meeting's sco.sco_id
  • principal_permissions.permission_id = 2

Quick Query Example to Verify Access Type #

If you want to check the access setting for a specific meeting, you can run this SQL query (replace YOUR_MEETING_SCO_ID with the target meeting's SCO ID):

SELECT 
  s.name AS meeting_name,
  s.is_public,
  pp.principal_id
FROM sco s
LEFT JOIN principal_permissions pp 
  ON s.sco_id = pp.sco_id 
  AND pp.permission_id = 2
WHERE s.sco_id = YOUR_MEETING_SCO_ID;

• If is_public = 1: The meeting is set to Public access
• If principal_id = -2: Authenticated Users access
• If principal_id = -3: My Company/Enterprise access
• If only specific user/group principal_ids are returned: Invited Only access

内容的提问来源于stack exchange，提问作者Ali Besharati