Update a SQL user's password

//native

type Cockroachdb = {

  token: string;

};

/**

 * Update a SQL user's password

 * Can be used by the following roles assigned at the organization, folder or cluster scope:

- CLUSTER_ADMIN

 */

export async function main(

  auth: Cockroachdb,

  cluster_id: string,

  name: string,

  body: { password: string },

) {

  const url = new URL(

    `https://cockroachlabs.cloud/api/v1/clusters/${cluster_id}/sql-users/${name}/password`,

  );

  const response = await fetch(url, {

    method: "PUT",

    headers: {

      "Content-Type": "application/json",

      Authorization: "Bearer " + auth.token,

    },

    body: JSON.stringify(body),

  });

  if (!response.ok) {

    const text = await response.text();

    throw new Error(`${response.status} ${text}`);

  }

  return await response.json();

}