CREATE TABLE和CREATE ANY TABLE特权之间的区别 [英] Difference between CREATE TABLE and CREATE ANY TABLE privileges

问题描述

我不明白这两种特权之间的区别.

I don't understand the difference between these two privileges.

我找到了这两种解释，但这对我没有帮助.

I found these two explanations but it's not helping me.

CREATE TABLE -> Enables a user to create a table owned by that user.

CREATE ANY TABLE -> Enables a user to create a table owned by any user in the database.

如果用户创建了一个表，它将由创建它的用户所有吗?我不明白.

If a user creates a table it's going to be owned by the user that created it right? I don't get it.

推荐答案

CREATE TABLE 特权使您可以在自己的模式中创建表.因此用户 scott 可以做到:

The CREATE TABLE privilege lets you create a table in your own schema. So user scott can do:

create table scott.mytable ( id number );

(创建任何表)特权使您可以在数据库中的任何模式中创建表.同样，用户 scott 可以做到:

The CREATE ANY TABLE privilege lets you create a table in any schema in the database. So again, user scott can do:

create table hr.employees ( id number );

也就是说，制作一个属于其他人的表.

That is, make a table that belongs to someone else.

这篇关于CREATE TABLE和CREATE ANY TABLE特权之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！