Hi!
OS: FreeBSD 3.3 stable
PG: 6.5.2 from ports collection
1. I create a database from my script and must GRANT all
tables, subsequences, indexes (amount 100) to some users I need.!
Yehh... GRANT does not allow me to grant all tables during one query.
If there any function(procedure) to do this for all tables, indexes
and etc. for one query?
2. I've read the manual, but can't understand Postgresql authentication
good.
2.1. I do "create user with password"
In pg_shadow this user has name "user1" and passwd "user1". All OK.
But user can go in without password at all. Why?
psql -u database
username: user1
passowrd: something or none
2.2. I want to give to users possibility to change their passwords.
But I don't know how and is it posible at all?!
Regards, Alexey V. Meledin
InterForge Developers Group, Saint-Petersburg
look_to: <www.etcompany.ru><www.businessweb.ru>
<www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>>
mail_to: <[EMAIL PROTECTED]><nick_as: <cureman>>>>
************