From: | Sidar López Cruz <sidarlopez(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Role privileges |
Date: | 2007-01-31 17:17:13 |
Message-ID: | BAY132-F33CE4F1E4E8B8B710F6A40CEA50@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-01-31 17:51:16 | Re: postmaster udp ports? |
Previous Message | Andrew Zahn | 2007-01-31 16:56:21 | postmaster udp ports? |