mhanney <[email protected]> writes: > regarding - "All users of Oracle have a default schema that is > different than the schema where the tables live so all objects have to > be fully qualified with the schema name", you could use public > synonyms in Oracle: > CREATE OR REPLACE PUBLIC SYNONYM TheTableName FOR > "TheSchemaOwner"."TheTableName";
I don't think the admins of the big Oracle cluster hosting at least a dozent different applications (with which I have to do absolut nothing) would appreciate that. I would rather assume the did the described setup exactly to not make all the table names global to all users as to avoid name clashes. :) -- Until the next mail..., Stefan.
pgpESt5wWWz3K.pgp
Description: PGP signature
