Thursday, February 08, 2007

Oracle SQL Developer - ORA-00942

I recently tried to user SQL Developer with a schema and found that I could not view packages, procedures or functions. I would get ORA-00942: table or view des not exist. I still don't know why, but granting SELECT_CATALOG_ROLE to the user solved the problem.

Update: I had a similar problem in Oracle Data Miner (Data Mining). I granted unlimited tablespace to the user and the problem went away. It may have been a tablespace issue for SQL Developer as well...

No comments: