与授予选项一起使用后，撤消在第一个用户上使用的选项 [英] Revoke option used on first user after using with grant option

问题描述

我正在研究Oracle数据库11g: 如果用户A使用以下方式对表'emp'授予用户B下列特权: Grant select on emp to userB WITH GRANT OPTION;

Im working on Oracle Database 11g: If user A gives the following privileges to user B on a table 'emp' using: Grant select on emp to userB WITH GRANT OPTION;

用户B使用以下命令将相同的信息提供给用户C: Grant select on emp to userC WITH GRANT OPTION;

User B gives the same to user C using: Grant select on emp to userC WITH GRANT OPTION;

一旦发生这种情况，用户A将使用以下方法: Revoke select on emp from userB;

Once this happens, user A uses this: Revoke select on emp from userB;

以下结果是什么? 我对此有些困惑.

What is the outcome of the following? Im a bit confused on this.

推荐答案

只要已授予用户B选择emp ... WITH GRANT OPTION"的权限，他就可以将此特权转发给其他人.如果特权被撤销，他将无法再这样做. (既不选择表emp也不允许将select授予其他主体)

As long as user B has been granted to "select on emp ... WITH GRANT OPTION" he may forward this privilege to somebody else. If the privilege is revoked he cannot do this anymore. (neither select table emp nor grant select to sombody else)

举一个简单的例子:GRANT CREATE TABLE to USER_A.只要USER_A拥有此特权，他就可以创建一个新表.如果特权被撤销，他将无法再这样做.当然，在这种情况下，他之前创建的表将不被删除.桌子保持原样. SELECT特权也是如此.

Take a simpler example: GRANT CREATE TABLE to USER_A. As long as USER_A has this privilege he can create a new tables. If the privilege is revoked he cannot do this anymore. In this case the table he created before will not be dropped, of course. The table stays as it is. The same applies for SELECT privileges.

这篇关于与授予选项一起使用后，撤消在第一个用户上使用的选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！