Permission Bitmask Consensus Audit

An IAM analytics team stores each user's enabled capabilities as an integer bitmask.

Table: user_permissions

• user_id: unique user identifier
• permissions: non-negative integer bitmask

Bitmask semantics:

• Bit value 1 at position k means capability k is enabled.
• Bit value 0 at position k means capability k is not enabled.

Task: Produce exactly one row with these two metrics:

1. common_perms: bitwise AND across all users (capabilities enabled for everyone)
2. any_perms: bitwise OR across all users (capabilities enabled for at least one user)

Output requirements:

• Return exactly these columns in this order: common_perms, any_perms
• Return exactly one row.

Supported submission environments:

• SQL (SQLite 3.27.2)
• Pandas (Python)

user_permissions:
| user_id | permissions |
|---------|-------------|
| 1       | 5           |
| 2       | 12          |
| 3       | 7           |
| 4       | 3           |

[
  {"common_perms":0,"any_perms":15}
]

user_permissions:
| user_id | permissions |
|---------|-------------|
| 10      | 14          |
| 11      | 10          |
| 12      | 6           |
| 13      | 2           |

[
  {"common_perms":2,"any_perms":14}
]

user_permissions:
| user_id | permissions |
|---------|-------------|
| 21      | 1023        |
| 22      | 1023        |
| 23      | 1023        |

[
  {"common_perms":1023,"any_perms":1023}
]