一个架构可以有多个用户吗? [英] Can one schema have multiple users?

问题描述

我有一个问题想知道用户和架构之间的确切区别? 一个模式可以有多个用户，如果可以，怎么办?

I have a question I wanted to know the exact difference between user and schema? Can one schema have multiple users, if yes how?

有人可以举例说明吗?

推荐答案

在Oracle中，用户等同于架构.所以答案是否定的.

In Oracle user is equivalent to schema. So the answer is no.

创建用户后，例如scott用户scott创建的所有对象都在其架构内.您可以像这样通过其他用户从scotts模式访问对象:

Once you create a user eg. scott all objects created by user scott are within his schema. You can access objects from scotts schema by another user like this:

select * from scott.emp;

这篇关于一个架构可以有多个用户吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！