still cannot see data in tables - plz help

Hi all.

according to Xaviers advice I have created a new user 'TUTOR' in win2000 - password TIGER ... have given him student_dba and student_oper privileges (on a db named student - thats the way it shows up in user & passwords on win2000)

I can log on to the student db as 'TUTOR' password 'TIGER' - fine .. I created 6 tabels and inserted a bunch of data .... granted select to public on all of thiose tables.

Now the part I do not get:

I have a java front end .... I can access the oracle db .... the combo boxes get filles with values from some tables. Now the user ( any user of that application - only on one PC - no net involved! ) can set some values and click 'FIND' .... and it comes up with no data and only the headings of that table(s).

When starting up that application I get a message:

java.sql.SQL.Exception: ORA-00942: Table or View not available

When using SQL Plus I can see all the data in all tables!!

the strange thing is that it must be somehow accessible as the boxes get filled ..... what have I done wrong .. or what have I missed???

I am struggeling along all day now .... and do not get anywhere... your help would be most appreciated !!!

Louise Received on Sat Aug 18 2001 - 13:26:00 CDT