Answers for "postgresql create database user grant"

SQL
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
0

postgresql grant owner to user

ALTER DATABASE name OWNER TO new_owner;
Posted by: Guest on June-04-2021
-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 create database user grant"

Code answers related to "SQL"

Browse Popular Code Answers by Language