Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 7: Line 7:
 
  [[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA]] [[public]] TO yourdbname;
 
  [[GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA]] [[public]] TO yourdbname;
 
  EOF
 
  EOF
 +
 +
 +
[[GRANT USAGE]]
  
 
== See also ==
 
== See also ==

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



GRANT USAGE

See also

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

Advertising: