************************************************* macOS 27 Golden Gate ************************************************ user@mac-27 ~ % sudo sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" ".tables" Password: access access_overrides active_policy admin expired integrity_flag managed_overrides policies user@mac-27 ~ % sudo sqlite3 -header -column "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT m.name AS table_name, p.cid AS pos, p.name AS column_name, p.type, p.\"notnull\" AS not_null, p.dflt_value AS default_value, p.pk FROM sqlite_master m JOIN pragma_table_info(m.name) p WHERE m.type = 'table' ORDER BY m.name, p.cid;" table_name pos column_name type not_null default_value pk ----------------- --- ------------------------------- ------- -------- ------------------------------------- -- access 0 service TEXT 1 1 access 1 client TEXT 1 2 access 2 client_type INTEGER 1 3 access 3 auth_value INTEGER 1 0 access 4 auth_reason INTEGER 1 0 access 5 auth_version INTEGER 1 0 access 6 csreq BLOB 0 0 access 7 policy_id INTEGER 0 0 access 8 indirect_object_identifier_type INTEGER 0 0 access 9 indirect_object_identifier TEXT 1 'UNUSED' 4 access 10 indirect_object_code_identity BLOB 0 0 access 11 flags INTEGER 0 0 access 12 last_modified INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access 13 pid INTEGER 0 0 access 14 pid_version INTEGER 0 0 access 15 boot_uuid TEXT 1 'UNUSED' 0 access 16 last_reminded INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access 17 one_time_reprompt_eligible INTEGER 0 0 access 18 reminder_count INTEGER 1 0 0 access_overrides 0 service TEXT 1 1 active_policy 0 client TEXT 1 1 active_policy 1 client_type INTEGER 1 2 active_policy 2 policy_id INTEGER 1 0 admin 0 key TEXT 1 1 admin 1 value INTEGER 1 0 expired 0 service TEXT 1 1 expired 1 client TEXT 1 2 expired 2 client_type INTEGER 1 3 expired 3 csreq BLOB 0 0 expired 4 last_modified INTEGER 1 0 expired 5 expired_at INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 integrity_flag 0 key TEXT 1 1 integrity_flag 1 value INTEGER 1 0 managed_overrides 0 service TEXT 1 1 managed_overrides 1 client TEXT 1 2 managed_overrides 2 client_type INTEGER 1 3 managed_overrides 3 auth_value INTEGER 1 1 0 managed_overrides 4 auth_reason INTEGER 1 0 managed_overrides 5 auth_version INTEGER 1 0 managed_overrides 6 csreq BLOB 0 0 managed_overrides 7 policy_id INTEGER 0 0 managed_overrides 8 indirect_object_identifier_type INTEGER 0 0 managed_overrides 9 indirect_object_identifier TEXT 1 'UNUSED' 4 managed_overrides 10 indirect_object_code_identity BLOB 0 0 managed_overrides 11 flags INTEGER 1 0 0 managed_overrides 12 last_modified INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 managed_overrides 13 one_time_reprompt_eligible INTEGER 0 0 managed_overrides 14 admin_auth_value INTEGER 1 0 policies 0 id INTEGER 1 1 policies 1 bundle_id TEXT 1 0 policies 2 uuid TEXT 1 0 policies 3 display TEXT 1 0 user@mac-27 ~ % ********************************************************************************************************************** **************************************************** macOS 15 Sequoia ************************************************ mac-15:~ user$ sudo sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" ".tables" Password: access active_policy expired access_overrides admin policies mac-15:~ user$ sudo sqlite3 -header -column "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT m.name AS table_name, p.cid AS pos, p.name AS column_name, p.type, p.\"notnull\" AS not_null, p.dflt_value AS default_value, p.pk FROM sqlite_master m JOIN pragma_table_info(m.name) p WHERE m.type = 'table' ORDER BY m.name, p.cid;" table_name pos column_name type not_null default_value pk ---------------- --- ------------------------------- ------- -------- ------------------------------------- -- access 0 service TEXT 1 1 access 1 client TEXT 1 2 access 2 client_type INTEGER 1 3 access 3 auth_value INTEGER 1 0 access 4 auth_reason INTEGER 1 0 access 5 auth_version INTEGER 1 0 access 6 csreq BLOB 0 0 access 7 policy_id INTEGER 0 0 access 8 indirect_object_identifier_type INTEGER 0 0 access 9 indirect_object_identifier TEXT 1 'UNUSED' 4 access 10 indirect_object_code_identity BLOB 0 0 access 11 flags INTEGER 0 0 access 12 last_modified INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access 13 pid INTEGER 0 0 access 14 pid_version INTEGER 0 0 access 15 boot_uuid TEXT 1 'UNUSED' 0 access 16 last_reminded INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access_overrides 0 service TEXT 1 1 active_policy 0 client TEXT 1 1 active_policy 1 client_type INTEGER 1 2 active_policy 2 policy_id INTEGER 1 0 admin 0 key TEXT 1 1 admin 1 value INTEGER 1 0 expired 0 service TEXT 1 1 expired 1 client TEXT 1 2 expired 2 client_type INTEGER 1 3 expired 3 csreq BLOB 0 0 expired 4 last_modified INTEGER 1 0 expired 5 expired_at INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 policies 0 id INTEGER 1 1 policies 1 bundle_id TEXT 1 0 policies 2 uuid TEXT 1 0 policies 3 display TEXT 1 0 mac-15:~ user$ ********************************************************************************************************************** ************************************************* macOS 26 Tahoe ***************************************************** sudo sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" ".tables" access active_policy expired policies access_overrides admin integrity_flag sudo sqlite3 -header -column "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT m.name AS table_name, p.cid AS pos, p.name AS column_name, p.type, p.\"notnull\" AS not_null, p.dflt_value AS default_value, p.pk FROM sqlite_master m JOIN pragma_table_info(m.name) p WHERE m.type = 'table' ORDER BY m.name, p.cid;" table_name pos column_name type not_null default_value pk ---------------- --- ------------------------------- ------- -------- ------------------------------------- -- access 0 service TEXT 1 1 access 1 client TEXT 1 2 access 2 client_type INTEGER 1 3 access 3 auth_value INTEGER 1 0 access 4 auth_reason INTEGER 1 0 access 5 auth_version INTEGER 1 0 access 6 csreq BLOB 0 0 access 7 policy_id INTEGER 0 0 access 8 indirect_object_identifier_type INTEGER 0 0 access 9 indirect_object_identifier TEXT 1 'UNUSED' 4 access 10 indirect_object_code_identity BLOB 0 0 access 11 flags INTEGER 0 0 access 12 last_modified INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access 13 pid INTEGER 0 0 access 14 pid_version INTEGER 0 0 access 15 boot_uuid TEXT 1 'UNUSED' 0 access 16 last_reminded INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 access_overrides 0 service TEXT 1 1 active_policy 0 client TEXT 1 1 active_policy 1 client_type INTEGER 1 2 active_policy 2 policy_id INTEGER 1 0 admin 0 key TEXT 1 1 admin 1 value INTEGER 1 0 expired 0 service TEXT 1 1 expired 1 client TEXT 1 2 expired 2 client_type INTEGER 1 3 expired 3 csreq BLOB 0 0 expired 4 last_modified INTEGER 1 0 expired 5 expired_at INTEGER 1 CAST(strftime('%s','now') AS INTEGER) 0 integrity_flag 0 key TEXT 1 1 integrity_flag 1 value INTEGER 1 0 policies 0 id INTEGER 1 1 policies 1 bundle_id TEXT 1 0 policies 2 uuid TEXT 1 0 policies 3 display TEXT 1 0 **********************************************************************************************************************