Visual Fox 6, Sql Server 2000, and Security.

[knopmike]

I'm migrating some corporate applications from vfp 6 front and back to vfp 6 front and sql2k back and don't have time to redesign security from the ground up.

Currently (vfp front and back) we use 3 netware groups (ro - read only, de - data entry, ad - admin) for every app; when the app runs, it's easy to determine which netware group a user belongs to and enforce certain security features.

Now our sql2k is running on a win2k server with netware userid's and passwords being replicated to the server. Netware app groups will become user groups on the win2k server and netware groups will eventually disappear. By using Windows authentication for sql2k on the win2k server, we can map the win2k app user groups to sql2k users and map built-in roles to them.

However, if a client on win nt 4 runs a vfp 6 app, how can the app determine which win2k user groups the client belongs to on the win2k server? Our network is netware and the win2k server that houses sql2k may or may not be part of an active directory (I couldn't flag a network guy at the time of this post).

Any help would be appreciated.

Thanks. Mike