can not desc or select user_objects

[kiltz]

Hi,

what could be the reason?

I want to select or describe the objects I can handle. So I try

>select * from all_objects;

"sp2-0561" is the answer.

Has anybody an anwer? I would be happy!

chris

[kiltz]

the only possibility to select dba_objects, all_objects or user_objects ist to connect as "INTERNAL". Other users can not select this views! I granted SELECT ANY TABLE to differend users and repeated the procedure, nothing changed! I run catalog.sql, nothing changed!

Any help?

chris

[jmodic]

Would you please provide your Oracle release? If it is 8.0 then it is a known bug....

[kiltz]

Indeed it is Oracle Version 8.0.5.0.0 !

Are there any bug fixes?

Thank you for your advice!

chris

[jmodic]

One of the possible workarounds would be not to use public synonyms in such cases. ALL_OBJECTS is a public synonym for a view SYS.ALL_OBJECTS.

So try to use full qualified names instead of synonyms, like:

SELECT * FROM SYS.ALL_SYNONYMS;

Hope it will work....

For bugfixes, search the Metalink or contact your Oracle Support.