Обсуждение: How to create schema-specific users?

"Tom Gordon" <tom@farechase.com> 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

Dnia 03-09-09 16:22, Użytkownik Tom Gordon napisał:
> 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.
Users, as well as roles aka groups are non-schema objects (they can own
other objects and mat be granted rights to other objects). What
particular functionality would you like to achieve using a user being
part of some other user's schema (except the ability to have multiple
separate namespaces for usernames)?

--
  _______
|  |||||| Michal Malecki, system analyst
|  ||||||
|  |||||| e.media Studio, Gliwice, PL
|e.media|
|__|||||| michal.malecki@e.media.pl