/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

10 votes219 views6 answers
Mysql set root password
SQL
10 votes169 views1 answer
Dba_dependencies
SQL
1 vote179 views1 answer
Name of today sql
SQL
1 vote306 views1 answer
Postgres set column based on another column
SQL
0 vote175 views1 answer
Drop procedure sql
SQL
0 vote186 views1 answer
Mysql custom sort order
SQL
13 votes181 views4 answers
What is sql
SQL
1 vote214 views1 answer
Mysql tables max count
SQL
4 votes199 views2 answers
Dbms output
SQL
0 vote172 views1 answer
Sql query to delete row by id
SQL