why is schema prefix required to reference my own table?
590974Aug 1 2007 — edited Aug 1 2007I login as system and create a table for a user with the user name as the prefix:
create table "user"."table1" ....
The table was created with owner being user. However, then I log in as user and do a
select * from table1 ..
I got the error message that the table does not exist.
I have to do
select * from user.table1 ....
then it works.
I was under the assumption that user is the owner of the table and it should be able to reference table1 without any schema prefix. Am I wrong with this assumption or it is something else that goes wrong?