I'm using VB5 SP3 on Win95/NT connecting to PostgreSQL V6.4x via ODBC.

There are certain application functions that can be access by users of different group. So I need advices on the following:

1. Is it better to create different users of different groups on database level or create a table containing these security information?

2. Certains fields in a table can be updated by super users but read-only or hided from normal users. So is it better to update the database from VB or by calling database functions/store procedures?

3. How do you call stored procedures from VB? I can't find related info anywhere.

TIA.

carolyn