Diskuse:155PIN2 Projekt - Informatika 2: Porovnání verzí
| Řádek 20: | Řádek 20: | ||
createuser -D -R -S -P <user> | createuser -D -R -S -P <user> | ||
CREATE SCHEMA <user>; | |||
ALTER SCHEMA b11 OWNER TO <user>; | |||
GRANT ALL ON geometry_columns TO <user>; | GRANT ALL ON geometry_columns TO <user>; | ||
GRANT SELECT ON spatial_ref_sys TO <user>; | GRANT SELECT ON spatial_ref_sys TO <user>; | ||
| Řádek 32: | Řádek 34: | ||
USER="$1" | USER="$1" | ||
SCHEMA=`echo $USER | cut -d'_' -f2` | |||
DB=pgis_pin2 | DB=pgis_pin2 | ||
createuser -D -R -S -P $1 | createuser -D -R -S -P $1 | ||
psql $DB -c "GRANT ALL ON geometry_columns TO $ | psql $DB -c "CREATE SCHEMA $USER;" | ||
psql $DB -c "GRANT SELECT ON spatial_ref_sys TO $ | psql $DB -c "ALTER SCHEMA $SCHEMA OWNER TO $USER;" | ||
psql $DB -c "GRANT ALL ON geometry_columns TO $USER;" | |||
psql $DB -c "GRANT SELECT ON spatial_ref_sys TO $USER;" | |||
exit 0 | exit 0 | ||
Verze z 21. 3. 2011, 19:31
Trac
htpasswd /opt/trac/pin2/.htpasswd user
trac-admin /opt/trac/pin2 permission add user student
Git
Soubor conf/gitolite.conf:
repo pin2/2011 RW+ = @landa
PostGIS
createuser -D -R -S -P <user>
CREATE SCHEMA <user>; ALTER SCHEMA b11 OWNER TO <user>; GRANT ALL ON geometry_columns TO <user>; GRANT SELECT ON spatial_ref_sys TO <user>;
#!/bin/sh
if [ -z $1 ] ; then
echo "usage: $0 <user>"
exit 1
fi
USER="$1"
SCHEMA=`echo $USER | cut -d'_' -f2`
DB=pgis_pin2
createuser -D -R -S -P $1
psql $DB -c "CREATE SCHEMA $USER;"
psql $DB -c "ALTER SCHEMA $SCHEMA OWNER TO $USER;"
psql $DB -c "GRANT ALL ON geometry_columns TO $USER;"
psql $DB -c "GRANT SELECT ON spatial_ref_sys TO $USER;"
exit 0
TODO
- navod pro git linux/windows