Oracle Synonym

最新推荐文章于 2024-09-27 10:30:29 发布

dingxy

最新推荐文章于 2024-09-27 10:30:29 发布

阅读量852

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库和Oracle 文章标签： oracle user schema table database function

本文链接：https://blog.youkuaiyun.com/dingxy/article/details/2879313

数据库和Oracle 专栏收录该内容

88 篇文章

订阅专栏

本文解释了Oracle数据库中同义词的概念及其用途。同义词作为表或视图的别名，可以提供安全性并减少SQL语句的复杂度。文章还介绍了同义词如何为远程对象提供位置透明性，并允许底层对象重命名或移动而不需要修改应用程序。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

# 问题内容：请问oracle中的同义词是何意思？
# 原讨论链接：http://community.youkuaiyun.com/expert/topicview1.asp?id=1803303
# 所属论坛：基础和管理审核组：Oracle
# 提问者：taozabc 解决者：hrb_qiuyb
# 感谢：hrb_qiuyb、yuanscar
# 关键字：
# 答案：

又有什么作用呢？
---------------------------------------------------------------

相当于alias(别名),比如把user1.table1在user2中建一个同义词table1
create synonym table1 for user1.table1;
这样当你在user2中查select * from table1时就相当于查select * from user1.table1;
优点自己总结吧。
---------------------------------------------------------------

A synonym is an alias for a schema object. Synonyms can provide a level of ecurity
by masking the name and owner of an object and by providing location transparency for remote objects of a distributed database. Also, they are convenient to use and reduce the complexity of SQL statements for database users.
Synonyms allow underlying objects to be renamed or moved, where only the synonym needs to be redefined and applications based on the synonym continue to function without modification.
You can create both public and private synonyms. A public synonym is owned by
the special user group named PUBLIC and is accessible to every user in a database.
A private synonym is contained in the schema of a specific user and available only
to the user and the user’s grantees.