Re: Driver name in Create user?

[Martin L. <ma...@li...>]

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