I am trying to create a shared server for community, and now stock=k with users privilege and roles, I get an error on QGIS when login with my user account.
Steps I did :
I revoked all privileges from public schema.
REVOKE ALL ON DATABASE sudanmap FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON ALL TABLES IN SCHEMA public FROM PUBLIC; REVOKE EXECUTE ON ALL FUNCTIONS IN SCHEMA public FROM PUBLIC;
I created role named userread only to view as demo.
CREATE ROLE userread;
Granted Connection to database, usage to public schema and Grant Select .
GRANT CONNECT ON DATABASE sudanmap TO userread; Grant USAGE ON SCHEMA public TO userread; GRANT SELECT ON ALL TABLES IN SCHEMA Public TO userread;
Created user with password, and grant userread to it.
CREATE USER open PASSWORD '123456789'; GRANT userread TO open;
Login to QGIS is successful. I can see my schema but I get this (failed to get layer).
What I try I grant all to my user still the same, only why he can see the layers by making him superuser.
What am doing wrong ?