Skip site navigation (1) Skip section navigation (2)

Re: Extended security/restriction to any role with login access

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: Domingo Alvarez Duarte <mingodad(at)gmail(dot)com>
Cc: Carol Walter <walterc(at)indiana(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Extended security/restriction to any role with login access
Date: 2008-06-27 13:44:33
Message-ID: 607359.23897.qm@web59503.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
ok, let try this .....

open the pg_hba.conf and check the line 

host    all         all         127.0..0.1/32          trust

and change to 

host    all         all         127.0..0.1/32          password



--- On Thu, 6/26/08, Domingo Alvarez Duarte <mingodad(at)gmail(dot)com> wrote:
From: Domingo Alvarez Duarte <mingodad(at)gmail(dot)com>
Subject: Re: [ADMIN] Extended security/restriction to any role with login access
To: lennin(dot)caro(at)yahoo(dot)com
Cc: "Carol Walter" <walterc(at)indiana(dot)edu>, pgsql-admin(at)postgresql(dot)org
Date: Thursday, June 26, 2008, 9:45 PM

I did the following:
-Connect as superuser postgres with pgadmin and create a user -> noaccess
CREATE ROLE noaccess LOGIN
  NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;

-Disconnect from the server
-Connect to the server with user 'noaccess' through pgadmin3, and I can see all databases/functions/schemas/roles.


What am I missing ?

On Thu, Jun 26, 2008 at 8:44 PM, Lennin Caro <lennin(dot)caro(at)yahoo(dot)com> wrote:


hello...

you can restric acces from all the databases in your cluster. When you use pgadmin3 this show all the databases but if you dont have access to the databases you cant see the struct of this.

check waht user use pgadmin3 for connect to databases 


create groups and add privileges to the group later add the users to the group







      

In response to

Responses

pgsql-admin by date

Next:From: Domingo Alvarez DuarteDate: 2008-06-27 14:35:46
Subject: Re: Extended security/restriction to any role with login access
Previous:From: Domingo Alvarez DuarteDate: 2008-06-27 05:43:51
Subject: Re: Extended security/restriction to any role with login access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group