...
Deployments using the described configuration should immediately upgrade to Registry v4.0.1, or to develop commit XXX or 13a0c8cfdd or later.
Deployments may also perform an audit, as described in Discussion, below.
...
Code Block | ||
---|---|---|
| ||
WITH t1 AS ( SELECT cm_identifiers.id,cm_identifiers.actor_identifier,cm_org_identities.co_id FROM cm_identifiers INNER JOIN cm_org_identities on cm_identifiers.org_identity_id=cm_org_identities.id WHERE cm_identifiers.actor_identifier IN ( SELECT username FROM cm_api_users WHERE co_id > 1 AND privileged = true ) ), t2 AS ( SELECT username,co_id FROM cm_api_users WHERE co_id > 1 AND privileged = true ) SELECT * FROM t1 LEFT JOIN t2 on t1.actor_identifier=t2.username WHERE t1.co_id <> t2.co_id; |
Tables to examine include cm_co_person_roles
, co_person_roles
, co_departments
, co_email_lists
, co_groups
, co_org_identity_links
, co_petitions
, co_services
, co_terms_and_conditions
, history_records
, and co_unix_cluster_groups
.
References
- CO-2146
- CO-2294