Difference between revisions of "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
[[EOF]] | [[EOF]] | ||
+ | == See also == | ||
+ | * {{GRANT}} | ||
− | + | [[Category:psql]] |
Revision as of 11:39, 27 September 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
See also
Advertising: