GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA

From wikieduonline
Revision as of 13:06, 23 June 2022 by Welcome (talk | contribs)
Jump to navigation Jump to search
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

Advertising: