postgres user identification
 

I am in the process of setting up a new DB server for the company.

So far I have PostgreSQL set up and running, with tables accessible to anyone in the network with the correct ODBC setup. However this setup is as a specific user.

Ideally what we would like is the following:

1) Set up ODBC on Windows clients to recognise the DB server
2) DB Server manages accounts for anyone trying to log in - create accounts on the fly

Normal users would be assigned to a default group, whilst any admin users would be setup to an admin group.

The real question is, is this possible? Is it hard? Any pointers on how to do it (i.e. do I need to use SAMBA as well as postgreSQL

Cheers

Dan

You can have Windows interface with Postgress easily using ODBC. Download psqlodbc.dll. There is a link on www.postgresql.org I think. The name is "Postgres-ODBC driver". Once you get the dll and register it, you will see Postgres as an option in your ODBC system DSN list. If you download the self-installing version, it will register the DLL for you.
If not, put in system32 folder and use

regsrv32 C:\path\to\psqlodbc.dll

on command line to register.