josh / new_pguser.sql
0 лайк(-ов)
0 форк(-ов)
1 файл(-ов)
Последняя активность
| 1 | CREATE USER newuser WITH PASSWORD 'your_secure_password' LOGIN; |
| 2 | |
| 3 | CREATE DATABASE newdatabase WITH OWNER = newuser; |
| 4 | |
| 5 | \c newdatabase |
| 6 | |
| 7 | GRANT ALL PRIVILEGES ON DATABASE newdatabase TO newuser; |
| 8 | GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO newuser; |
| 9 | GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO newuser; |
Новее
Позже