I'm trying to create a form in 9i where any user can access the form and retrieve data from the tables.

The problem i'm having is that when the users (expect for the owner of the tables) log on to the form, no data is retrieved when a query is executed.

I've granted various privileges to the other users but they still can't retrieve any data.

Is it possible to create a trigger or code into the form which tables to look for, i.e. 'username.tablename', or will I have to created some kind of public synonym.

Any suggestions will greatly appreciated.