/SQL/Enter into postgresql database,create user and grant Access

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;

Source: gist.github.com

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;

-1

Source: gist.github.com

Similar codes

0 vote264 views1 answer
Mysql c commands
SQL
0 vote258 views1 answer
Mysql beautifier terminla
SQL
0 vote250 views1 answer
Oracle sql generate list of days
SQL
3 votes261 views3 answers
Restart mysql mac
SQL
0 vote242 views1 answer
Java input type sql date
SQL
6 votes238 views1 answer
Oracle rank() over (partition)
SQL
0 vote234 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote330 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote245 views1 answer
Postgres truncate with cascade
SQL
3 votes259 views2 answers
Df to sql pandas sql achemy
SQL