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

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

From: "Domingo Alvarez Duarte" <mingodad(at)gmail(dot)com>
To: lennin(dot)caro(at)yahoo(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-26 21:45:19
Message-ID: c2f38c3e0806261445q5f36a2d7j2172b7f19a75b42b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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: kartikDate: 2008-06-27 05:33:20
Subject: Query
Previous:From: Lennin CaroDate: 2008-06-26 18:44:27
Subject: Re: Extended security/restriction to any role with login access

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