Using the GRANT sql worked. I read more about it in the postgresql manual. Thanks.
GRANT USAGE ON SCHEMA topology TO PUBLIC; Then It never fully took effect till I restarted the server, *su -* *rcpostgresql restart* *exit* Done. Now, that part about giving access to PUBLIC on the template_postgis database. This is because without it, a non-superuser cannot create a database of their own when using: *createdb -T template_postgis newdb* *createdb: database creation failed: ERROR: permission denied to copy database "template_postgis"* I tried using the similar GRANT for databases but it doesn't mention anything about allowing users to copy. Only connect, so I tried that: *GRANT CONNECT ON DATABASE template_postgis TO PUBLIC;* But still, cannot create a database without being postgres user. Not sure if I need to maybe make user of ALTER like so: *ALTER DATABASE template_postgis OWNER TO PUBLIC;* Or try, *ALTER ROLE saultdon CREATEDB IN DATABASE template_postgis;* Does one of those give me copy permissions because CONNECT hasn't. Thanks for the help so far with changing schema privileges. Donovan On Sun, May 6, 2012 at 1:31 AM, Sandro Santilli <s...@keybit.net> wrote: > On Sat, May 05, 2012 at 10:58:24PM -0700, Donovan Cameron wrote: > > > When I to check the postgis version with the user saultdon, it says > > postgis_topology not installed. I have to be superuser to use it. > ... > > *NOTICE: Function postgis_topology_scripts_installed() not found. Is > > topology support enabled and topology.sql installed?* > > Try > GRANT usage on schema topology to public; > > Or variations of the above. When satisfied consider doing it on the > template database. > > --strk; > > ,------o-. > | __/ | Delivering high quality PostGIS 2.0 ! > | / 2.0 | http://strk.keybit.net - http://vizzuality.com > `-o------' > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
