Re: naming tables without including owner name
->From: knutv@Hadrian.Boers.no (Knut Espen Vonheim)
->Subject: naming tables without including owner name
->Date: 28 Jun 1994 15:54:08 +0200
->Reply-To: knutv@Hadrian.Boers.no (Knut Espen Vonheim)
->Organization: Oslo B|rs Informasjon
->
->Hello!
->
->A quick question about naming tables:
->
->Can I create tables without having my name included in the table name?
->
->I.eg. having knutv.tsttbl becoming tsttbl for all users.
->
->This causes us some trouble when we try to devolop client software in
->PowerBuilder.
->
->Any hints or comments are appreciated!
->
->---------------------------------------------------------
->From: Knut E. Vonheim Sign.: SoM
->Comp: A/S OBI
->Addr.: Fred Olsensgt. 1
-> 0152 Oslo Phone : + 47 22 34 18 06
-> Norway Fax : + 47 22 42 68 47
->e-mail knutv@boers.no Beeper: + 47 966 99357
->---------------------------------------------------------
->In my opinion, it shouldn't be just my opinion !!!!
Look into using synonyms for all of your tables, of the form:
CREATE SYNONYM tsttbl FOR knutv.tsttbl;
Depending on your version of Informix, either:
1. all synonyms are public by default, or
2. you can declare public synonyms if you have DBA privileges, or
3. you can provide a script to your users to have them create their own
set of synonyms. (Applies to all versions, of course, but is least
desirable option.)
Regards,
Alan ___________________________
______________________| R. Alan Popiel |__________________________
\\ Internet: | Martin Marietta, SLS | /
\\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. /
)Voice: | Denver, CO 80201-0179 USA | (
/ 303-977-9998 |___________________________| (But you knew that!) \\
/________________________) (____________________________\\