Skip to content

Instantly share code, notes, and snippets.

@garystafford

garystafford/grafanareader.sql

Created October 11, 2020 12:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save garystafford/59133cee615cd25134890f13b4553ec3 to your computer and use it in GitHub Desktop.
Save garystafford/59133cee615cd25134890f13b4553ec3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grafanareader.sql
CREATE USER grafanareader WITH PASSWORD 'grafana1234';
GRANT USAGE ON SCHEMA public TO grafanareader;
GRANT SELECT ON public.sensor_data TO grafanareader;
GRANT SELECT ON public.temperature_humidity_summary_minute TO grafanareader;
GRANT SELECT ON public.air_quality_summary_minute TO grafanareader;
GRANT SELECT ON public.light_summary_minute TO grafanareader;
GRANT SELECT ON public.motion_summary_minute TO grafanareader;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment