, 2008 at 9:10 PM, Lennin Caro <[EMAIL PROTECTED]> wrote:
> in pgadmin3:
>
> Menu -> Display
> check the option "System Object"
>
> this show you the catalogs of postgresql "pg_xxxx"
>
> change the grants to users here
>
> --- On *F
s,
> function are public
>
> --- On *Fri, 6/27/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 PROT
pg_hba.conf and check the line
>
> hostall all 127.0.0.1/32 trust
>
> and change to
>
> hostall all 127.0.0.1/32 password
>
>
>
> --- On *Thu, 6/26/08, Domingo Alvarez Duarte <[EMAIL PROTECTED]>* wrote:
>
&
owns. Postgres owns my databases so I can't do it this
> way, but it could be done.
>
> Carol
>
>
> On Jun 26, 2008, at 1:04 PM, Domingo Alvarez Duarte wrote:
>
> Hello !
>>
>> I'm trying to use postgresql in an application that by design will give
>&
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
Hello !
I'm trying to use postgresql in an application that by design will give
access to users to a subset of the database.
For example for customers access to products_view (wich will only show
public offers), orders (only their own orders).
I'll provide an application as user interface for t
