few securiry questions

From: R D <mrk279(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: few securiry questions
Date: 2000-05-29 09:17:32
Message-ID: 20000529091732.11423.qmail@web205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi there,I'm migrating from MySQL to PgSQL and
I have few questions on PgSQL securiry:
1. How can I forbid to some users to create tables
in some databases which they can acccess.
2. How can I GRANT/REJECT some privileges on all
objects in a database TO/FROM some users, since i
can't type "GRANT ALL ON * TO SOMEUSER;" in PgSQL. Is
there any functional analog?
3. How can I reject to some users connections to
some databases from any host using password
authentication?
4. Why this pg_hba.conf does not alow uses from
192.168.200.X to connect to the databases with message
telling that there was no entry for 192.168.200.x in
pg_hba.conf?
# pg_hba.conf

local all trust
host all 0.0.0.0 0.0.0.0 reject
host all 192.168.200.0 255.255.255.0 password

Thanks in advance!

Rumen

__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Eugene Karpachov 2000-05-29 11:19:09 grant select,update - bug or feature?
Previous Message Ragnar Kjørstad 2000-05-29 03:29:18 Re: Very Urgent!!! Help Me !!!