fix: Add permissions for logging sink to write to pubsub topic

Part of team#84 (closed)

We currently see errors with the logging sink being unable to write to the pubsub topic we have for logging. This change adds the missing permission.