SQL Kerberos principal changes; switching some uses of OS.Path.joinDirFile to OS...

[hcoop/domtool2.git] / src / plugins / domtool-postgres

diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres
index ded559d..4f85765 100755 (executable)
--- a/src/plugins/domtool-postgres
+++ b/src/plugins/domtool-postgres
@@ -12,7 +12,8 @@ case $1 in
                        vos create -server afs -partition a -name db.$USERNAME -maxquota 5000
                        fs mkmount -dir /afs/.hcoop.net/common/.databases/$USERNAME -vol db.$USERNAME -rw
                        vos release common.databases
-                       fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl databases l
+                       fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl system:postgres l
+                       fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl system:mysql l
                        fs setacl -dir /afs/hcoop.net/common/databases/$USERNAME -acl system:backup rl
                fi
 
@@ -20,8 +21,7 @@ case $1 in
                        sudo -u postgres psql -c "CREATE USER $USERNAME" template1
                        mkdir -p $DIR
                        chown postgres:postgres $DIR
-                       fs setacl -dir $DIR -acl postgres write
-                       fs setacl -dir $DIR -acl databases none
+                       fs setacl -dir $DIR -acl system:postgres write
                        fs setacl -dir $DIR -acl system:backup rl
 
                        sudo -u postgres psql -c "CREATE TABLESPACE user_$USERNAME OWNER $USERNAME LOCATION '$DIR'" template1