| Error ORA-00942 [message #61879] |
Tue, 08 June 2004 03:59  |
Will
Messages: 32
Registered: January 2000
|
Member |
|
|
I don't manage to access to the differents objects I have created (functions, procedures, packages...)
I work with sql/plus with Oracle 8.1.7.
Error ORA-00942 : Table or view doesn't exist.
I wonder if someone malware broke something...
Someone got an idea ?
Thank u
|
|
|
|
|
|
| Re: Error ORA-00942 [message #61931 is a reply to message #61879] |
Thu, 10 June 2004 21:06  |
KING
Messages: 9
Registered: February 2002
|
Junior Member |
|
|
|
Hi, if u have created those objects with names within quotes then make sure u call the object in exactly same lower case or upper case
|
|
|
|
| Re: Error ORA-00942 [message #62363 is a reply to message #61931] |
Fri, 16 July 2004 22:16 |
Murali
Messages: 54
Registered: December 1999
|
Member |
|
|
Hi
Although this table certainly exists and the user was granted the right to select this table.
The problem is that procedures don't respect roles; only directly granted rights are respected. So, that means that "table_owner" has to regrant the right to select:
connect "table_owner"/"Password"
grant select on "TABLENAME" to "OTHER_USER";
Hope it works!
Regards
Murali
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
