Allow another user to access my Oracle table
Has he tried "SELECT COUNT(*) FROM smahala.fishtable;"? If you grant select on a table in one schema to another schema that user should be able to access it by including the schema name in the query. However, if NOAA is using virtual private databases, then there may be other obstacles that prevent you from sharing data. If there isn't much data, you can try to export to a flat file and have the other person import the flat file. but this should probably get resolved by your internal DBA's. Since they know how the database is configured. You might also want to verify that you are using the same Oracle database.