>>We have problem creating our forms based on back-end datasource.
>>Our setup...
>> Back-end : SQL Server 6.5, Contains table(s) and view(s).
>>Front-end : Visual Foxpro 5.0, Contains Remote View(s) based on SQL
>>
>> At SQL end users have access to tables/views and some of users have access
>>to some specific fields only whereas the forms are accessible to all users.
>>We have noticed that if user does not have permission to any one of the fields
>>SQL returns an error.
>>
>>How can we dynamically modify our view at run time, depending on what fields
>>user can see, without changing the original view.
>
>I guess you should use different view definitions (try to do it programmatically using e.g. CURSORSETPROP()) for different users depending on their security status (could be implemented as individual/group user accounts for VFP app).

Thanx for the response,
I have tried CURSORSETPROP but it does't work because the users has either full rights or part rights to the table at the back-end. So i am looking for a method by which i can select only those fields to which user is having rights.