Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"

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 ON DATABASE "yourdbn...")
 
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
  
−
  psql -h you_dp_ip -U postgres -p 5432  << EOF
+
  [[psql -h]] you_dp_ip [[-U postgres]] [[-p 5432]] << EOF
−
  CREATE DATABASE "yourdbname";
+
  [[CREATE DATABASE]] "yourdbname";
−
  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
 +
 +
 +
 +
 +
 +
== Related ==
 +
* GRANT ALL PRIVILEGES ON DATABASE * to yourusername;
 +
* <code>[[GRANT CONNECT]]</code>
 +
* <code>[[GRANT USAGE]]</code>
 +
* <code>[[GRANT ON ALL TABLES IN SCHEMA]]</code>
 +
 +
== See also ==
 +
* {{GRANT ALL}}
 +
* {{GRANT}}
 +
 +
[[Category:DB]]

Latest revision as of 14:52, 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]

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

Advertising: