<< Click to Display Table of Contents >> Navigation: Supported database systems > PostgreSQL > Users |
Replace new_user_name and password with appropriate values for your new user.
CREATE ROLE new_user_name WITH LOGIN PASSWORD 'password';
https://www.postgresql.org/docs/current/sql-createrole.html
GRANT ALL ON ALL TABLES IN SCHEMA PUBLIC TO new_user_name;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO new_user_name;
GRANT ALL ON ALL FUNCTIONS IN SCHEMA public TO new_user_name;
GRANT ALL ON ALL PROCEDURES IN SCHEMA public TO new_user_name;
GRANT ALL ON ALL ROUTINES IN SCHEMA public TO new_user_name;