Change operator cluster role to be read only by default

[atoulme]

Component(s)

auto-instrumentation

Is your feature request related to a problem? Please describe.

The operator cluster role as defined here:
https://github.com/open-telemetry/opentelemetry-helm-charts/blob/main/charts/opentelemetry-operator/templates/clusterrole.yaml
This role gives write access to many objects across all namespaces.

Describe the solution you'd like

This should be kept down to a minimum of privileges:

• Can it be filtered down to specific namespaces?
• Can we document why the operator requires the right to, say, delete services?

Describe alternatives you've considered

No response

Additional context

No response

[atoulme]

I have shown it is possible to reduce rights of the operator greatly with https://github.com/otel-warez/whitegloves-operator