OraFAQ Forum: Forms » ORA-00942: table or view does not exist

Home » Developer & Programmer » Forms » ORA-00942: table or view does not exist (Oracle forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00942: table or view does not exist [message #510841]

Wed, 08 June 2011 01:10

ankur8819
Messages: 17
Registered: May 2011
Location: India

Junior Member

Hi,
The form actually consists of one block that refers to a table in DB(Datablock).
The functionality of the form is to run some logic and then just insert data in the table .This happens on press of a button.

The problem is when I run the form thru' Admin Id it runs successfully but when I run the form through some other user it gives me the error.

The grants on the table are Public.
GRANT DELETE, INSERT, SELECT, UPDATE ON XYZ TO PUBLIC;

What could be the problem?
I am attaching the snapshot for the same.

Thanks.

Attachment: untitled.jpg
(Size: 39.33KB, Downloaded 1176 times)

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #510850 is a reply to message #510841]

Wed, 08 June 2011 01:57

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What could be the problem?

1/ Lack of owner name in the query and no synonym
2/ Lack of privilege on the target table of the other user

Regards
Michel

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #510868 is a reply to message #510850]

Wed, 08 June 2011 02:52

cookiemonster
Messages: 13973
Registered: September 2008
Location: Rainy Manchester

Senior Member

Grants to public should prevent option 2. So that leaves 1.

Report message to a moderator

Re: ORA-00942: table or view does not exist [message #510882 is a reply to message #510868]

Wed, 08 June 2011 03:26

ankur8819
Messages: 17
Registered: May 2011
Location: India

Junior Member

/forum/fa/9074/0/

I removed the table name(schema.table_name) from DML Data Target Name and it started working fine.

Not sure of the reason behind it.

Attachment: untitled.PNG
(Size: 17.61KB, Downloaded 3523 times)

[Updated on: Wed, 08 June 2011 03:28]

Report message to a moderator

Previous Topic:	LOV
Next Topic:	FRM-40654

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 28 07:15:11 CST 2025