| 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: | Whole Thread | Raw Message | 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 !!! |