PostgreSQL role user Grant

PostgresQL / May 20, 2023 May 25, 2023

Create user

$ sudo -u postgres createuser

Creating Database

$ sudo -u postgres createdb

Grant all to tables

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO new_user;