Difference between revisions of "GRANT ALL PRIVILEGES ON SCHEMA"

From wikieduonline
Jump to navigation Jump to search
Line 3: Line 3:
 
  [[CREATE USER]] yourusername WITH PASSWORD yourpassword;
 
  [[CREATE USER]] yourusername WITH PASSWORD yourpassword;
 
  [[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

Revision as of 15:47, 5 July 2023

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

See also


See also

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

Advertising: