Users

<< Click to Display Table of Contents >>

Navigation:  Supported database systems > PostgreSQL >

Users

Creating a new user

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;