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/
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 !!! |