limited access to a table


2007-05-04 04:52:33 AM
delphi63
Hi,
I want to write an application in Delphi 7 in which two users must be
defined. The first should have full access to all fields in a table in
a database defined in SQL server 2000. The other has not access to
certain fields. The application first asks the users to identify
themselves with appropriate username and password. Then allows them to
work with that table. SQL server uses widows authentication. Any
suggestion how I can do it?
Surena