Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"
Jump to navigation
Jump to search
(Created page with " psql -h you_dp_ip -U postgres -p 5432 << EOF CREATE DATABASE "yourdbname"; CREATE USER yourusername WITH PASSWORD yourpassword; GRANT ALL PRIVILEGES ON DATABASE "yourdbn...") |
|||
| Line 1: | Line 1: | ||
| − | psql -h you_dp_ip -U postgres -p 5432 << EOF | + | [[psql -h]] you_dp_ip [[-U postgres]] [[-p 5432]] << EOF |
| − | CREATE DATABASE "yourdbname"; | + | [[CREATE DATABASE]] "yourdbname"; |
| − | CREATE USER yourusername WITH PASSWORD yourpassword; | + | [[CREATE USER]] yourusername WITH PASSWORD yourpassword; |
| − | GRANT ALL PRIVILEGES ON DATABASE "yourdbname" to yourusername; | + | [[GRANT ALL PRIVILEGES ON DATABASE]] "yourdbname" to yourusername; |
[[GRANT ALL PRIVILEGES ON SCHEMA]] public to yourusername; | [[GRANT ALL PRIVILEGES ON SCHEMA]] public to yourusername; | ||
| − | GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO yourdbname; | + | [[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA]] [[public]] TO yourdbname; |
EOF | EOF | ||
Revision as of 13:06, 23 June 2022
psql -h you_dp_ip -U postgres -p 5432 << EOF CREATE DATABASE "yourdbname"; CREATE USER yourusername WITH PASSWORD yourpassword; GRANT ALL PRIVILEGES ON DATABASE "yourdbname" to yourusername; GRANT ALL PRIVILEGES ON SCHEMA public to yourusername; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO yourdbname; EOF
Advertising:
