I recently wanted to share regular access rights with one user of a server and I realized that a simple
CREATE USER and
GRANT ALL ON DATABASE commands didn't let him run a simple
SELECT on the data.
I would like to grant rights to all tables from a given database to a specified user, but I am not sure if it is the best idea to grant him access to whole schema
public as I don't know if it would allow some kind of privilege escalation. Is there any other way?