roles.set_members

[pavish]

• API gets the new members of a role, compares with existing member list, grants role to new members, and revokes role from removed members.

Request parameters:

database_id: Database['id'];
role_oid: Role['oid'];
members: Role['oid'][];

Response:
RoleInfo of role_oid (Refer mathesar/rpc/roles.py)

API behaviour:

• Existing members of role base are a,b,c
• Request:

  database_id: 1,
  role_oid: 1, //oid of `base`
  members: [a, x, y] // oids of `a, x, y` (should be integers but name is specified here for ease of understanding)
  

• API should revoke base from b and c.

   revoke base from b;
   revoke base from c;
  

• API should grant base to x and y.

   grant base to x;
   grant base to y;
  

• a should NOT be modified.
• All these should happen in a single transaction.
• If an empty array is sent for members, all member roles should be removed.

[pavish]

We would require configuring the WITH ADMIN option for this function for each member role, but that can be deferred to after BETA.