>>In your TNSNAMES.ORA file, you have something like:
>>
>>AMCS = ....
>>
>>You use AMCS for the server name. Think of this as an ALIAS for the server and all the parameters needed to connect to the SID.
>
>Ok, I did that I changed amcs.world to amcs in the tnsnames.ora. Then when I did the remote view wizard, something GOOD happened, it recognized 1 table in oracle 8 database!
>Now what do I have to do in order to open a table of my choice and issue foxpro sql statements?
>Thanks again..
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.
Mark McCasland
Midlothian, TX USA