权限问题
在一本书上看到一个问题：
In which of the following cases is the object creator NOT always granted CONTROL prvilege?
A:table
B:view
C:index
D:package
操作了一遍，发现creator always have the control privilge on the object.
到底选择哪个？
In which of the following cases is the object creator NOT always granted CONTROL prvilege?
A:table
B:view
C:index
D:package
操作了一遍，发现creator always have the control privilge on the object.
到底选择哪个？
4 同行回答
自动赋予view 的creator control权限要求 creator在每个基表上有control权限！ 收起
可以明确告诉你选B view
The owner of a view
(usually the individual who created the view) automatically receives all privileges
available—with the exception of the CONTROL privilege—for that view, along with
the right to grant any combination of those privileges (except CONTROL privilege) to
other users and groups. A view owner will receive CONTROL privilege for a view only
if he or she also holds CONTROL privilege for every base table the view references. 收起
The owner of a view
(usually the individual who created the view) automatically receives all privileges
available—with the exception of the CONTROL privilege—for that view, along with
the right to grant any combination of those privileges (except CONTROL privilege) to
other users and groups. A view owner will receive CONTROL privilege for a view only
if he or she also holds CONTROL privilege for every base table the view references. 收起
实践是真知。 收起