Création user en lecture seul

 

sudo -u postgres -i

 

CREATE USER servicenav LOGIN PASSWORD 'Password';
GRANT CONNECT ON DATABASE contact TO servicenav;
GRANT CONNECT ON DATABASE side TO servicenav;
GRANT CONNECT ON DATABASE vac TO servicenav;

 

GRANT USAGE ON SCHEMA public TO servicenav;
GRANT SELECT ON ALL TABLES IN schema public TO servicenav;

Revision #2
Created 31 October 2024 22:49:12 by Cavallone
Updated 25 November 2024 18:28:40 by Cavallone