new_pguser.sql
· 333 B · MySQL
Raw
CREATE USER newuser WITH
PASSWORD 'your_secure_password'
LOGIN;
CREATE DATABASE newdatabase WITH
OWNER = newuser;
\c newdatabase
GRANT ALL PRIVILEGES ON DATABASE newdatabase TO newuser;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO newuser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO newuser;
| 1 | CREATE USER newuser WITH |
| 2 | PASSWORD 'your_secure_password' |
| 3 | LOGIN; |
| 4 | |
| 5 | CREATE DATABASE newdatabase WITH |
| 6 | OWNER = newuser; |
| 7 | |
| 8 | \c newdatabase |
| 9 | |
| 10 | GRANT ALL PRIVILEGES ON DATABASE newdatabase TO newuser; |
| 11 | GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO newuser; |
| 12 | GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO newuser; |