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

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
>
>
>