Users specific to a Database
Hi All,
I am new to this postgres and now struggling with creation of a user
specific to a database, so the user can login to that specific database
and can do the activities as per the given credentials and can not touch
or see any information from other databases. Can any one please help me
in this regard?
I really appreciate for the help in advance.
*Thanks and Regards
Ranjan Rashmi sahoo | UGSI OSDB Team
Unisys Global Services India | 4F-361 SJR I-Park | Whitefield Road,
Bangalore 560066 | Phone +91804032-3322 | Mobile +91-9449251441 | Net
757-3322
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.
Attachments:
On May 29, 2007, at 6:09 , Sahoo, Ranjan Rashmi wrote:
I am new to this postgres and now struggling with creation of a
user specific to a database, so the user can login to that specific
database and can do the activities as per the given credentials and
can not touch or see any information from other databases. Can any
one please help me in this regard?
Redirected to -general, as this is not a question that pertains to
the development of PostgreSQL.
Have you looked at pg_hba.conf? You can limit which users connect to
which databases.
http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html
Hope this helps.
Michael Glaesemann
grzm seespotcode net
Sahoo, Ranjan Rashmi wrote:
Hi All,
I am new to this postgres and now struggling with creation of a user
specific to a database, so the user can login to that specific database
and can do the activities as per the given credentials and can not touch
or see any information from other databases. Can any one please help me
in this regard?
Start there http://www.postgresql.org/docs/8.2/interactive/user-manag.html
And please, future question send to the general or novice mailing list.
This list is focused on postgres development.
Zdenek