Revision 6822
Added by Aaron Marcuse-Kubitza almost 12 years ago
| Makefile | ||
|---|---|---|
| 248 | 248 |
db: mk_db rm_initial_public _always ; |
| 249 | 249 |
|
| 250 | 250 |
mk_db: _always |
| 251 |
-echo "CREATE USER public_;"|$(psqlAsAdmin) |
|
| 251 | 252 |
-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin) |
| 252 | 253 |
-echo "CREATE USER bien_read PASSWORD '$(bienReadPassword)' IN ROLE bien \ |
| 253 | 254 |
NOINHERIT;"|$(psqlAsAdmin) |
| ... | ... | |
| 267 | 268 |
echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin) |
| 268 | 269 |
echo "DROP USER IF EXISTS bien_read;"|$(psqlAsAdmin) |
| 269 | 270 |
echo "DROP USER IF EXISTS bien;"|$(psqlAsAdmin) |
| 271 |
echo "DROP USER IF EXISTS public_;"|$(psqlAsAdmin) |
|
| 270 | 272 |
|
| 271 | 273 |
reinstall_db: _always rm_db db ; |
| 272 | 274 |
|
Also available in: Unified diff
Makefile mk_db, schemas/pg_hba*.conf: Added passwordless public_ user with access to just the database schema. Note that in PostgreSQL, only users with explicit GRANT permissions on a table can read data in that table, but all DB users with a login can view all table schemas.