Function grantRoleTo

src/gcp/cloudsql/permissionsSetup.ts:453–474

(
  options: Options,
  instanceId: string,
  databaseId: string,
  role: string,
  email: string,
  schema: string = DEFAULT_SCHEMA,
)

}

export async function grantRoleTo(
  options: Options,
  instanceId: string,
  databaseId: string,
  role: string,
  email: string,
  schema: string = DEFAULT_SCHEMA,
): Promise<void> {
  // Upsert new user account into the database.
  const projectId = needProjectId(options);
  const { user, mode } = toDatabaseUser(email);
  await cloudSqlAdminClient.createUser(projectId, instanceId, mode, user);

  const fdcSqlRole = fdcSqlRoleMap[role as keyof typeof fdcSqlRoleMap](databaseId, schema);
  await executeSqlCmdsAsSuperUser(
    options,
    instanceId,
    databaseId,
    /** cmds= */ [`GRANT "${fdcSqlRole}" TO "${user}"`],
    /** silent= */ false,
  );
}