Synonyms in Database
A synonym is another name for a table or view. Synonyms are used so a table name does not need to be qualified by specifying another user name. Typically database administrators create and manage synonyms. And synonyms created by themselves are managed by the owners of all those synonyms. Since there are two types of synonyms, creating these will require two types of system-level privileges. Generally, all users can create synonyms with the private option. However, to develop synonyms with the public option, the user must be a database administrator or have that level of privilege. But MySQL server doesn't support synonyms yet.
Comments
Post a Comment