>>>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.
******
Mark, I was just happy to be able to connect with oracle8( with your help) and see what I can do from there such as use the oracle tables in my trusty foxpro environment. The code below is where it bogs down.

STORE SQLSTRINGCONNECT('dsn=amcs;uid=amcs_guy;pwd=amcspwd');
TO gnConnHandle
IF gnConnHandle < 0
= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
ELSE
= MESSAGEBOX('Connection made', 48, 'SQL Connect Message')
*= SQLDISCONNECT(gnConnHandle)
ENDIF
= SQLEXEC(gnConnHandle, 'SELECT noun FROM amcs_equipment ', 'MyCursor')