Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 users and single db
Message
De
20/09/2001 03:18:36
 
 
À
07/09/2001 09:42:06
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00553715
Message ID:
00558623
Vues:
17
I usually Use the exact syntax:

SCHEMAOWNER.TABLENAME

i.e.

SELECT * FROM USER1.TABLENAME;

Or you can use a concept called "Synonyms"..

You login as the user that can't see the tables and do something like:

create synonym TABLENAME ON USER1.TABLENAME;
Then

select * from tablename;

will work

It works this way on most databases.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform