Have two table with same name but created by different user

saurabh7878 · New User Joined: 02 Jun 2005 Posts: 16

Hi all
I have a small doubt...
Suppose there are two users ..User1 and User2...
Now both the user create the same table Customer and made them public....
First doubt is that is it possible...
If yes then my second doubt is that i m the third user User3 and access Customer without giving any user name in prefix...which table i m going to view...

Thanks in advance
Saurabh

jkbytes

Hi,

Its quite possible, and if in the case you have created a customer table from user3 it will retreive the data from that table.

saurabh7878 · New User Joined: 02 Jun 2005 Posts: 16

Hi Jkbytes
Thanks for the first response ...........But my question is if the third user has not created the table then which table he is going to view...The table created by the USER1 or the table created by the USER2

jkbytes

hi saurabh,

if you are trying to access a table that is not created under your userid, then you may get the following error code when you are trying to retreive the records.

saurabh7878 · New User Joined: 02 Jun 2005 Posts: 16

Thanks JK for the quick response ...
But still one doubt left and that is why he will not be able to access the table created by the user1 and user2.....They both have created the table and made it pubilc..
Thanks
SAurabh

rajakishore · New User Joined: 04 Apr 2005 Posts: 10 Location: Hyderabad

Hi Saurabh,

User3 has to give an unique identifier to recognize which table he has to access.

Here either he can give User1.Tablename or User2.Tablename

if u give just the Tablename without any qualifier then surely it will throw

error saying Tabelname not found.

Ragards,
Raj

saurabh7878 · New User Joined: 02 Jun 2005 Posts: 16

Thanks Raj for clearing the doubt
SAurabh