"Tom Gordon" <[EMAIL PROTECTED]> wrote: > I'm missing something. How do I create a user that is just for a specific > schema, and not a global user? I see in the docs how to create schemas and > users, but not a schema-specific user.
The only think that you can do is specify on your pg_hba.conf file the databases that the user can connect to. If you run Postgres 7.3.X these line are an example to add to your pg_hba.conf file: host <your_db> <user> <host-source> <netmask> password of course this line is valid only for remote connection, for local connection: local <your_db> <user> trust Refer to the PostgreSQL Administrator's Guide, chapter "Client Authentication" for a complete description. Regards Gaetano Mendola ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org