Overview of Synonyms (193)
A synonym is an alias for any table, view, materialized view, sequence, procedure,
function, package, type, Java class schema object, user-defined object type, or another
synonym. Because a synonym is simply an alias, it requires no storage other than its
definition in the data dictionary.
Synonyms are often used for security and convenience. For example, they can do the
following:
■ Mask the name and owner of an object
■ Provide location transparency for remote objects of a distributed database
■ Simplify SQL statements for database users
■ Enable restricted access similar to specialized views when exercising fine-grained
access control
You can create both public and private synonyms. A public synonym is owned by the
special user group named PUBLIC and every user in a database can access it. A
private synonym is in the schema of a specific user who has control over its
availability to others.
Synonyms are very useful in both distributed and nondistributed database
environments because they hide the identity of the underlying object, including its
location in a distributed system. This is advantageous because if the underlying object
must be renamed or moved, then only the synonym needs to be redefined.
Applications based on the synonym continue to function without modification.
Synonyms can also simplify SQL statements for users in a distributed database system.
The following example shows how and why public synonyms are often created by a
database administrator to hide the identity of a base table and reduce the complexity
of SQL statements.
同義詞
1. 隱藏一個資料庫物件的名字和擁有者
2. 隱藏分散式環境中遠端物件的位置
3. 簡化資料庫使用者的 SQL 語句
4. 用於實現更精細的訪問控制
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-982103/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Check the existence of public synonyms Remove the public synonymsREM
- Oracle synonyms總結Oracle
- Public Synonyms for Data Dictionary Views (263)View
- Flutter OverviewFlutterView
- ORA-01775: looping chain of synonymsOOPAI
- dart class overviewDartView
- Stormstarter-OverviewORMView
- Overview of PartitioningView
- Overview of Database CheckpointsViewDatabase
- Overview of Unix ResourcesView
- oracle function overviewOracleFunctionView
- Item Import OverviewImportView
- Overview of Extents(11)View
- Overview of Partitioned IndexesViewIndex
- Overview of Tablespaces (38)View
- Overview of Views (174)View
- Overview of Datafiles (62)View
- Overview of Segments (22)View
- Overview of Availability in a CDBViewAI
- 2.4 Overview of Services in a CDBView
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- [英] TensorFlow OverviewView
- Deadlock Overview and DiscussionView
- Overview of Data Blocks(二)ViewBloC
- Overview of Clusters (238)View
- Overview of Tables (154)View
- Overview of Dimensions (191)View
- Overview of Indexes (194)ViewIndex
- Elasticsearch:使用同義詞 synonyms 來提高搜尋效率Elasticsearch
- PostgreSQL DBA(193) - 資料傾斜下的HashJoinSQL
- 2.6.2 Overview of Flashback PDB in a CDBView
- 2.2.7 Overview of PDB Lockdown ProfilesView
- An Overview of PostgreSQL & MySQL Cross ReplicationViewMySqlROS
- Spring Cloud: Overview 概述SpringCloudView
- SAP S/4 HANA OverviewView
- DeepLearning – Overview of Sequence modelView