> 1. What OS is the DB on
> 2. What OS's are the users going to use.
> 3. If windows use OLEDB faster and more secure & easier, only problem
> will be error return codes, can be the same for ODBC. if all is
Linux - Unix
> use the ODBC.
PostgreSQL is in a Linux server; Web interface will also be Linux (PHP as
far as I know) and the ODBC access is under Windows.
> 3. Develop different views and rules, and give grants only to views to the
users.
> your words, IMHO would be the way I go here, based on your info. If
the
> access
> to your db is passwd and other security set, you should have no real
> problems. But
> Murphy still will be lurking, just ensure your users can not get
around your
> security.
> I am new to postrges but I am Orace cert & SQL Svr, many years here &
> ODBC/OLEDB.
Indeed, I plan to use crypted passwords as the security solution.
Thanks !
Jose A. Cortina