Re: Synonyms are a pain!

From: <tjmxyz_at_my-deja.com>
Date: 2000/05/09
Message-ID: <8f8u0l$qre$1@nnrp1.deja.com>#1/1

hi!

I'll just add my strategy here in case it helps. My application has a locally stored Look Up Table or INI file With a list of the tables used by the application: TABLENAME OWNER INSTANCE
STYLES PDM1 PDM.RUNTIME.DK Everytime I execute an SQL statement I look up the values for the table in OWNER and INSTANCE

SELECT * FROM gettable("STYLES");

Which changes the SQL to PDM1.STYLES_at_PDM.RUNTIME.DK; OR PDM1.STYLES or whtever is in the Look up tables.

Each user group has there own Look up Table

I looked at 'alter session set current_schema = ...'

But my problem was some tables could be shared between several user groups.

This I can handle dividing the tables over tablespaces , servers or whatever I wanted.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 09 2000 - 00:00:00 CDT