Skip to content

Instantly share code, notes, and snippets.

@samyakb

samyakb/TIL.md

Created July 2, 2021 11:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save samyakb/2c10dfded3f0deade5c4bfeb7f3be905 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save samyakb/2c10dfded3f0deade5c4bfeb7f3be905 to your computer and use it in GitHub Desktop.
Download ZIP
create a user and give access to database
Raw
TIL.md 
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;
@samyakb
Copy link
Author

samyakb commented Jul 2, 2021

https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment