I can't see the tables created by SYS.
564010Feb 26 2007 — edited Feb 26 2007Greetings everyone,
I have a problem, im an absolute beginner in the Oracle lands, so please bear with me if this question is too obvious.
I created a database "MyDatabase" using Oracle's DB configuration manager, logged in as user SYS (with SQLDeveloper), created a table "MyTable" with some fields (also using SQLDeveloper) and then logged in as another user "MyUser" which i created from the Oracle Enterprise Manager (as SYS), i also changed "MyUser" to the SYSTEM tablespace.
Now, the problem is that i can't see the table "MyTable" as "MyUser" in the SQLDeveloper, im getting a "ORA-00942 the table or view doesn't exist". Am i doing something wrong? Perhaps im lacking privileges or roles (im investigating that at the moment) but shouldn't i get a "you don't have enough privileges" instead of "this table doesn't exist"?
Thank you in advance for your time and patience, any help is appreciated.
Cheers,
Magnus