ReliDB

Oracle uses synonyms to point users to other schema objects when the user does not have direct access to that schema. This is generally accomplished by creating a synonym owned by public to a private schema object. Once the public synonym is created all users have access to the private schema object. [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: ddl, generate, move, Oracle, recreate, synonym. Comments: None