Difference between revisions of "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA"
Jump to navigation
Jump to search
(Created page with " psql -h you_dp_ip -U postgres -p 5432 << EOF CREATE DATABASE "yourdbname"; CREATE USER yourusername WITH PASSWORD yourpassword; GRANT ALL PRIVILEGES...") |
|||
(9 intermediate revisions by 4 users not shown) | |||
Line 4: | Line 4: | ||
[[GRANT ALL PRIVILEGES ON DATABASE]] "yourdbname" to yourusername; | [[GRANT ALL PRIVILEGES ON DATABASE]] "yourdbname" to yourusername; | ||
[[GRANT ALL PRIVILEGES ON SCHEMA]] public to yourusername; | [[GRANT ALL PRIVILEGES ON SCHEMA]] public to yourusername; | ||
− | [[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA | + | [[GRANT ALL PRIVILEGES ON ALL TABLES]] IN SCHEMA [[public]] TO yourdbname; |
− | EOF | + | [[EOF]] |
+ | |||
+ | |||
+ | == Related == | ||
+ | * <code>[[GRANT ON ALL TABLES IN SCHEMA]]</code> | ||
+ | * [[GRANT SELECT]] | ||
+ | * [[GRANT CONNECT ON DATABASE]] | ||
+ | |||
+ | == See also == | ||
+ | * {{GRANT ALL}} | ||
+ | * {{GRANT}} | ||
+ | |||
+ | [[Category:psql]] | ||
+ | [[Category:SQL]] |
Latest revision as of 14:55, 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]
See also[edit]
Advertising: