首页 > 数据库技术 > 详细

OCP考试专项 [1z0-062]-Q1:CDB与PDB权限

时间:2020-04-10 12:30:06      阅读:81      评论:0      收藏:0      [点我收藏+]

In your multitenant container database (CDB) containing pluggable database (PDBs), you
granted the CREATE TABLE privilege to the common user C##ADMIN in root and all PDBs.
You execute the following command from the root container:
SQL > REVOKE create table FROM C##ADMIN;
What is the result?

A. It executes successfully and the CREATE TABLE privilege is revoked from C##ADMIN in root only.
B. It fails and reports an error because the CONTAINER=ALL clause is not used.
C. It excludes successfully and the CREATE TABLE privilege is revoked from C##ADMIN in root and all PDBs.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E. It executes successfully and the CREATE TABLE privilege is revoked from C##ADMIN in all PDBs.

Answer: A
Explanation: 在多租户环境里面,REVOKE…FROM…命令默认缺省选项为 container=current ,也就是回收当前容器数据库的权限。题目告知是在根容器(CDB$ROOT)里面执行的语句,因此只会回收根容器的权限。知识拓展如下图

技术分享图片

OCP考试专项 [1z0-062]-Q1:CDB与PDB权限

原文:https://www.cnblogs.com/askscuti/p/12672339.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!