Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
* <code>[[GRANT CONNECT]]</code> | * <code>[[GRANT CONNECT]]</code> | ||
* <code>[[GRANT USAGE]]</code> | * <code>[[GRANT USAGE]]</code> | ||
| − | + | * <code>[[GRANT ON ALL TABLES IN SCHEMA]]</code> | |
== See also == | == See also == | ||
Revision as of 11:11, 16 December 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
Related
See also
Advertising:
