Last active
October 8, 2020 06:41
-
-
Save aamsur-mkt/0cf4465076a78a3aa837499873792186 to your computer and use it in GitHub Desktop.
Create user psql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ sudo -u postgres psql | |
| postgres=# create user myuser with encrypted password 'myfuser'; | |
| postgres=# grant all privileges on database yourfdatabasename to myfuser; | |
| postgres=# GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myfuser; | |
| postgres=# alter default privileges in schema public | |
| grant SELECT, INSERT, UPDATE, DELETE on tables to liman; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
GRANT USAGE ON SCHEMA public TO dimas1 ;