Difference between revisions of "GRANT ALL PRIVILEGES ON DATABASE"
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}} | ||
Revision as of 13:07, 23 June 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, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE
Advertising:
