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...")
 
Line 5: Line 5:
 
  [[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]]

Revision as of 13:06, 23 June 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
Retrieved from "https://www.wikieduonline.com/index.php?title=GRANT_ALL_PRIVILEGES_ON_ALL_TABLES_IN_SCHEMA&oldid=151032"

Advertising: