Table Names Query
Posted in 1994
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Security, Permissions & Auditing
The answer to my question may be well known to someone with real
Informix experience, which is something I lack. I'm trying to RTFM,
but there are _so many_ FMs!
Logged in as "barry", I cold start Informix Version 5 and run a simple
database populate program that creates a database, grants DBA access
to PUBLIC, and then create tables alpha, beta, and gamma. When I use
dbaccess to inspect the database, I see tables alpha, beta, and gamma.
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. We expect to create the database, run tests,
tune the benchmarks, and then destroy the database. We'll recreate
the database when we run tests once or twice a year.
The ESQL/C statements
$CREATE DATABASE foo IN :space WITH LOG MODE ANSI;
$GRANT DBA TO PUBLIC;
were used to create the database.
A sample table create statement in the database load program is
$CREATE TABLE alpha ( .... ) LOCK MODE ROW;
Thanks,
Barry Wolman
Pittsburgh, PA