oracle切换schema,mysql、orcl中database、schema、user之间的关系

 2023-09-28 阅读 31 评论 0

摘要:对于MySQL而言,“database 数据库” 和 “schema 模式” 是同一件事。具体区分如下表: In MySQL: server instance == not identified with catalog, just a set of databasesdatabase == schema== catalog == a namespace wit

对于MySQL而言,“database 数据库” 和 “schema 模式” 是同一件事。具体区分如下表:

In MySQL:

  • server instance == not identified with catalog, just a set of databases
  • database == schema == catalog == a namespace within the server.
  • user == named account, who can connect to server and use (but can not own - no concept of ownership) objects in one or more databases
  • to identify any object you need (database name + object name)

In Oracle:

  • server instance == database == catalog == all data managed by same execution engine
  • schema == namespace within database, identical to user account
  • user == schema owner == named account, identical to schema, who can connect to database, who owns the schema and use objects possibly in other schemas
  • to identify any object you need (schema name + object name)

详细阅读:

1.What's the difference between a catalog and a schema in a relational database?

2.Relationship between catalog, schema, user, and database instance

版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。

原文链接:https://hbdhgg.com/3/101785.html

发表评论:

本站为非赢利网站,部分文章来源或改编自互联网及其他公众平台,主要目的在于分享信息,版权归原作者所有,内容仅供读者参考,如有侵权请联系我们删除!

Copyright © 2022 匯編語言學習筆記 Inc. 保留所有权利。

底部版权信息