----- Original Message -----
From: "Jaco van Staden" <ja...@cy...>
To: <sql...@li...>
Sent: Thursday, May 31, 2001 9:14 PM
Subject: Driver name in Create user?
> Hi
>
> What is the driver name, database username, password when I create user?
> Is it necessary to fill this in?
Driver name is Pg (reference to DBD::Pg). set username to 'postgres' and
leave password blank, if using default install. that should do it in
single-user machines and trusted environments. however, if you want to
restrict db access with username and password, here's one way to do it:
1. Connect to sql-ledger database as user postgres:
psql database -U postgres
2. Assign user postgres a password:
ALTER USER postgres WITH PASSWORD 'admin_password';
3. Create new user:
CREATE USER user WITH PASSWORD 'password';
4. Assign appropriate permissions to all sql-ledger tables
GRANT SELECT,INSERT,DELETE,UPDATE ON
acc_trans, ap, ar, chart, customer,
customertax, defaults, gl, invoice, makemodel,
parts, partstax, tax, vendor, vendortax
TO user;
5. Enable postgresql password check:
set access levels in pg_hba.conf from trust to crypt
6. set new db username and password in sql-ledger admin.
--
martin
|
