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 <[EMAIL PROTECTED]> wrote: From: Domingo Alvarez Duarte <[EMAIL PROTECTED]> Subject: Re: [ADMIN] Extended security/restriction to any role with login access To: [EMAIL PROTECTED] Cc: "Carol Walter" <[EMAIL PROTECTED]>, [email protected] 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 <[EMAIL PROTECTED]> 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
