Importance of Synonym in Oracle Database. Hello Everyone, Today I will discuss about Synonym in Oracle as Synonym play important role in database to hide information of object. Before Starting this blog please go through my previous blogs of SQL in my archive folder. Let’s Discuss about Synonym. Synonym in database is an object which is basically used as alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. We generally use synonyms for granting access to an object from another schema and you don't want the users from which Schema it’s own the object. In Another word we can say synonym is an alias for any table, view, snapshot, sequence, procedure, function, or package. Because a synonym is simply an alias, it requires no storage other than its definition in the data dictionary. Synonyms are basically used for security purpose and convenience. For example, Synonym can do the following: · Hide the name and
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.