What privileges should configure with read-only db user?


#1

Issue Summary

A summary of the issue and the browser/OS environment in which it occurs.

Technical details:

  • Redash Version:3.0.0+b3134
  • Browser/OS: Firefox / Ubuntu 14.04
  • How did you install Redash: provisioning script

I try to make read only db user to redash to access data by below command
BEGIN; CREATE ROLE user_name LOGIN PASSWORD 'secretpassword'; GRANT CONNECT ON DATABASE database_name TO user_name; GRANT USAGE ON SCHEMA public TO user_name; GRANT SELECT ON ALL TABLES IN SCHEMA public TO user_name; ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user_name; COMMIT;
althrough its ok to connect and run SQL command , but theres no obejct panel in the left as a full access user do

update: can not execute sql command …

Full Access users`s panel with object viewer
https://i.imgur.com/dItrV5b.png

read only users panel , no object viewer

https://i.imgur.com/xt0Y95O.png

what`s the correct priviledges to a readonly user and still have the object viewer ??