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 ??