Search Postgresql Archives

Re: [ADMIN] Regarding access to a user

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear Tomasz
I had done the same but still the problem is like that the user is able to access all the databases in the current server. Even the order is like same and if I comment the second line(all access) then the error is there.
Please provide solution for the same.

Thanks & Regards,
Shashwat Nigam
| Software Engineer | Geographical Information System
Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 |


-----Original Message-----
From: Tomasz Ostrowski [mailto:tometzky@xxxxxxxxxxxxx]
Sent: Thursday, August 21, 2008 2:37 PM
To: Shashwat_Nigam
Cc: pgsql-general@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] Regarding access to a user

On 2008-08-21 10:53, Shashwat_Nigam wrote:

> host    all         all         127.0.0.1/32          md5
> host    HMRI_database   hmri    127.0.0.1/32          md5
> in the above case hmri is user and HMRI_database. But still when user
> is log in as 'hmri' it is able to access all the databases.

Order matters:
host    HMRI_database   hmri    127.0.0.1/32          md5
host    all         all         127.0.0.1/32          md5

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux