Answers for "postgresql grant user access to database"

50

postgres create user grant all privileges

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;
Posted by: Guest on September-01-2020
1

Enter into postgresql database,create user and grant Access

sudo -u postgres psql postgres
#Create user, database, and grant permission
CREATE USER kodekloud_gem WITH PASSWORD 'LQfKeWWxWD';
CREATE DATABASE kodekloud_db10;
GRANT ALL PRIVILEGES ON DATABASE "kodekloud_db10" to kodekloud_gem;
Posted by: Guest on January-08-2022

Code answers related to "postgresql grant user access to database"

Browse Popular Code Answers by Language