Difference between revisions of "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA"
Jump to navigation
Jump to search
(One intermediate revision by one other user not shown) | |||
Line 9: | Line 9: | ||
== Related == | == Related == | ||
− | + | * <code>[[GRANT ON ALL TABLES IN SCHEMA]]</code> | |
+ | [[GRANT SELECT]] | ||
== See also == | == See also == |
Latest revision as of 14:58, 15 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[edit]
See also[edit]
Advertising: