Difference between revisions of "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
[[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 == | ||
| + | [[GRANT ON ALL TABLES IN SCHEMA]] | ||
== See also == | == See also == | ||
Revision as of 14:40, 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
GRANT ON ALL TABLES IN SCHEMA
See also
Advertising:
