Re: How to create schema-specific users?

"Tom Gordon"  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                   password

of course this line is valid only for remote connection, for local
connection:

local         
trust

Refer to the PostgreSQL Administrator's Guide, chapter "Client
Authentication" for
a complete description.



Regards
Gaetano Mendola