Difference between revisions of "GRANT ALL PRIVILEGES ON SCHEMA"
Jump to navigation
Jump to search
| (3 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
[[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]] | + | [[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 | ||
| − | + | == Related == | |
| − | + | * <code>[[GRANT ALL PRIVILEGES ON]]</code> | |
| + | * [[ERROR: permission denied for schema public]] | ||
== See also == | == See also == | ||
Latest revision as of 15:47, 5 July 2023
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
Related[edit]
See also[edit]
Advertising:
