Can create table, but can't describe it.
557564Jan 23 2008 — edited Jan 23 2008hello. I got some weird error. I have some a temporary user generated by a script. The user can create tables, but it cannot describe the tables.
If I log in using sqlplus, I can create tables, but when I do a describe, I get the error:
ORA-04043: object TABLENAME does not exist.
When I try the query: select table_name from user_tables, I can see that the table name.
Doesn't seem like the rest of my accounts are affected. So I don't think there's something wrong with my instance. (?)
I suspect the temporary user is missing a grant? Anyways, if you have seen this problem, perhaps you can help me out. Thanks.