mosher

I need to give a user a single database that they will have full control
over. I am assuming this means giving them ownership of the database,
but I have no idea how to do that, even after looking through the manual
and the mailing list archive. How do I give a user ownership of a
database? Or if there's a better way of granting them full access
(creating and editing tables, etc.) what is it, and how do I do it?

Thanks,
Rob Mosher.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

josh

Robert,


CREATE USER joe WITH PASSWORD 'jehosaphat' CREATEDB;
\c - joe
CREATE DATABASE joes_db;
\c - postgres
ALTER USER joe WITH NOCREATEDB;

then edit pg_hba.conf to have a line where joe can only connect to joes_db.

--
-Josh Berkus
Aglio Database Solutions
San Francisco


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings