Which are not an advantages of a synonym?
-
Alias for a schema object
-
Provide security by hiding the name of the object
-
Provide security by hiding the schema owner of the object
-
Reduce complexity in SQLs by creating short synonyms names for objects with long names
-
By granting privilege to synonym, granting privilege to the underlying object can be avoided
Synonyms provide several advantages including creating aliases for schema objects, hiding object names and schema owners for security, and reducing SQL complexity with short names. However, granting privileges on a synonym does NOT automatically grant privileges on the underlying object - you must still grant privileges directly on the base object. Privileges must be granted on the actual table, view, or other object that the synonym references, not on the synonym itself.