• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
• Download
• Purchase

Download Buy

MaxDB Maestro online Help

Specifying synonym options

Specify synonym options according to your needs. The detailed description is given below.
 

Owner

Select the owner for the synonym. By default, only the owner of an object can perform various operations with the object. In order to allow other users to operate it, privileges must be granted. (However, users that have the superuser attribute can always access any object.)

Comment

Specify a comment to the synonym.

Table

Specify the base object that the synonym references. The table must not denote a temporary base table. The user must have a privilege for the specified table. Only the name of the current user is permitted as the schema name. The synonym name can be specified anywhere instead of the table name. This has the same effect as specifying the table name for which the synonym was defined.

Public

If specified, the synonym name must not be identical to the name of a synonym defined with Public option. A synonym is generated that can be accessed by all users.

Otherwise, a private synonym is generated that is only known by the current user. In this case, the synonym name must not be identical to the name of an existing base table, view table, or a private synonym of the current user. If a synonym with the same name and the PUBLIC attribute exists, it cannot be accessed by the current user until the private synonym has been dropped.