Difference between revisions of "GRANT ALL PRIVILEGES ON 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 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
 +
 +
 +
 +
 +
 +
{{Schema}}

Revision as of 14:51, 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



Schema, search_path, \dn+, GRANT ALL PRIVILEGES ON SCHEMA

Retrieved from "https://www.wikieduonline.com/index.php?title=GRANT_ALL_PRIVILEGES_ON_SCHEMA&oldid=208942"

Advertising: