/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 vote144 views1 answer
Add column not null with default value postgres
SQL
5 votes169 views2 answers
Mysql where in array
SQL
0 vote154 views1 answer
Mysql wait_timeout
SQL
0 vote149 views1 answer
Php mysqli install
SQL
0 vote138 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote150 views1 answer
Yesql
SQL
1 vote151 views1 answer
Postgresql contains
SQL
0 vote148 views1 answer
Sql alternative to max statement
SQL
0 vote163 views1 answer
How to open mysql in docker
SQL
0 vote154 views1 answer
Oracle date winter time
SQL