Re: Table Names Query
->Subject: Table Names Query
->Date: 20 Sep 1994 16:47:49 -0400
->Reply-To: barry@telerama.lm.com
->Organization: Telerama Public Access Internet, Pittsburgh, PA
->
...
->When a colleague logged in as "oz" uses dbaccess to inspect the
->database, he sees tables barry.alpha, barry.beta, barry.gamma.
->
->What must I do to ensure that _everyone_ sees tables alpha, beta, and
->gamma? I should say that we're developing a benchmark, not a
->production database. ...
->
->Thanks,
->Barry Wolman
->Pittsburgh, PA
Look into the use of synonyms. Depending on your sub-level, i.e. xx in
Informix version 5.xx, you may or may not have public synonyms. If public
synonyms are not available, then you can create a script with statements
like
CREATE SYNONYM alpha FOR barry.alpha;in it, and have each of your users run the script before doing anything
else.
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!) \\
/________________________) (____________________________\\