>>In the Open [table] dialog box, there is a check box at the bottom to list all User tables. make sure that one is checked. Otherwise, all you see are the tables for the user ID you logged on with. You will only see tables that you have been granted SELECT privileges on. So, if you have a user schema you need to Select, Update, Insert and/or Delete data from, you have to set this up on the Oracle side using the GRANT command.
>>
>>I would create ROLEs for ReadOnly users and EditUsers. You have to have DBA or similar privilege to create roles.
>>
>>Create role MyApp_ReadOnly
>>Create role MyAPP_Edit
>>Grant select on schema.table_name to MyApp_ReadOnly
>>Grant insert, update, delete on schema.table_name to MyApp_Edit
>>Grant MyApp_ReadOnly to some_user
>>Grant MyApp_Edit to another_user
>>
>>You have to repeat 3 and 4 for each table.
>
>Are you describing creating a remote view? I have done that and I happen to be the dba here(a newbie). When the browse screen appears, it is VERY SLOW to display all 7000 records, takes 20 mins. Is something wrong?

I was describing on setting up table privileges in Oracle. I can not hink of any reason to be retrieving 7000 records from Oracle or SQL Server. Have you created indexes in Oracle on the table you are retriveing data from? Oracle tables are just like VFP tables in that performance will suck unless you have an index on everything you could using as retrieval filters. Available bandwidth is also a factor.