Omitting this parameter uses the schema of the creator as the schema of the object. Schema specifies the schema of the object specified in object_name. Synonym_name specifies the alternate object name to be referenced by users and applications. Public synonyms can be created only by a user with CREATE PUBLIC SYNONYM system privilege. Omitting this parameter makes a synonym private, and usable only by the creator. PUBLIC is a keyword specifying that this synonym is available to all users. The syntax to create a synonym is: CREATE synonym_name To simplify remote table access through database links, a synonym can allow single-word access to remote data, hiding the specific object name and the location from users of the synonym. You can create synonyms for the following:Īll synonyms are schema objects that are stored in the data dictionary of the database in which they are created.
0 kommentar(er)
