Role privileges - Mailing list pgsql-admin

From Sidar López Cruz
Subject Role privileges
Date
Msg-id BAY132-F33CE4F1E4E8B8B710F6A40CEA50@phx.gbl
Whole thread Raw
List pgsql-admin
I create this connected to postgres database:
create role prueba_role with nosuperuser nocreatedb nocreaterole nologin
noinherit;
revoke all on database prueba_roles from prueba_role cascade;
revoke create on database prueba_roles from prueba_role cascade;
create user sidar with password 'sidar' login in role prueba_role;

Then connect to prueba_roles database with user sidar.
I guess that with these configuration the user cannot create tables, but I
can do it.

How to reestrict users to one database access and how to allow only SELECT
permited?

_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Ordering problem with varchar (DESC) - from general ml.
Next
From: Andrew Zahn
Date:
Subject: postmaster udp ports?