Difference between revisions of "GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA"

From wikieduonline
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]] [[public]] TO yourdbname;
+
  [[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

Advertising: