[ADMIN] Password crypted storage utilisation

2000-05-30 Thread Loïc TREGOUËT
    Hie , hope someone can help me       I 'm trying to secure my database so i would like to use crypted password for authentification. But if i do this with pg_hba.conf like : local  all    crypt passwords are still stored in clear ! I don't wan't that superu

Re: [ADMIN] few securiry questions

2000-05-30 Thread Peter Eisentraut
R D writes: > 1. How can I forbid to some users to create tables > in some databases which they can acccess. You can't. Working on that ... > 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 Pg

Re: [ADMIN] grant select,update - bug or feature?

2000-05-30 Thread Eugene Karpachov
Mon, May 29, 2000 at 08:51:10PM -0700, Stephan Szabo write: > This is a known issue in the 7.0 foreign key implementation. The short Thank you, now it's clear for me. > It's something that will get fixed, it's just a question of how and when. ^^ It's just what

Re: [ADMIN] Bug or Feature ?

2000-05-30 Thread Norbert Meissner
Dear Karel, thank you for answers to my "minor" problems. It seems, that I have to take some care on designing tables for speed or robustness. I found out that the int8 type needs also much more time on calculations. I haven't tried it with numeric, but I think the result is even more worse. No