View previous topic :: View next topic
|
Author |
Message |
saurabh7878 Warnings : 1 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 |
|
Back to top |
|
|
jkbytes
Active User
Joined: 19 Feb 2005 Posts: 139 Location: South Africa
|
|
|
|
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. |
|
Back to top |
|
|
saurabh7878 Warnings : 1 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 |
|
Back to top |
|
|
jkbytes
Active User
Joined: 19 Feb 2005 Posts: 139 Location: South Africa
|
|
|
|
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.
Code: |
SQLCODE = -204; ERROR: USER03.CUSTOMER IS AN UNDEFINED NAME.
SQLSTATE = 42704 SQLSTATE RETURN CODE. |
|
|
Back to top |
|
|
saurabh7878 Warnings : 1 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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
saurabh7878 Warnings : 1 New User
Joined: 02 Jun 2005 Posts: 16
|
|
|
|
Thanks Raj for clearing the doubt
SAurabh |
|
Back to top |
|
|
|