Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
[[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 == | == Related == | ||
| + | * GRANT ALL PRIVILEGES ON DATABASE * to yourusername; | ||
* <code>[[GRANT CONNECT]]</code> | * <code>[[GRANT CONNECT]]</code> | ||
* <code>[[GRANT USAGE]]</code> | * <code>[[GRANT USAGE]]</code> | ||
| Line 14: | Line 19: | ||
== See also == | == See also == | ||
| + | * {{GRANT ALL}} | ||
* {{GRANT}} | * {{GRANT}} | ||
[[Category:DB]] | [[Category:DB]] | ||
Latest revision as of 14:52, 20 September 2024
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]
- GRANT ALL PRIVILEGES ON DATABASE * to yourusername;
GRANT CONNECTGRANT USAGEGRANT ON ALL TABLES IN SCHEMA
See also[edit]
Advertising:
