帮看下这个OCP题的答案
Choose three
Which three are true about granting object privileges on tables, views, and sequences?
A) UPDATE can be granted only on tables and views.
B) DELETE can be granted on tables, views, and sequences.
C) REFERENCES can be granted only on tables and views.
D) INSERT can be granted on tables, vews, and sequences.
E) SELECT can be granted only on tables and views.
F) ALTER can be granted only on tables and sequences.
Answer:ACF
(解析:update 和 delete 只能在表和视图上授权,不能在 sequence 上。
只有 SELECT 和 ALTER 权限对序列有效;
)
查了很多,答案大部都给的是ACF ,有的给的是AEF,
AC 我能理解,F 为什么对呢,说是 alter 只能给tables and sequences , 意思是 alter 权限不能给视图是么,但是我看视图应该是可以修改的吧 12C 谢谢