Accessing another user's tables

-> form's code) as scott.tablename. Instead, a colleague suggested using
-> the unadorned tablename and creating (public) synonym(s)
-> for scott's tables.

I like public synonyms because you don't have to create them again and again for each user, and you can move the tables to another user and recreate the synonyms without worrying about whose code explicitly calls the old user.table name. Received on Thu Jun 09 1994 - 16:14:00 CEST