Are the privileges on underlying table automatical

2019-07-19 10:39发布

If a user has SELECT, INSERT privileges on the underlying table of a view, would he automatically have the same privileges on views (created on the table) as well or does he need to be granted those?

For instance, suppose Bob has INSERT privileges on the table EMPLOYEES. Does he also have INSERT privileges on a view EMPLOYEENAMES which has only the names of the employees?

PLEASE NOTE: I am working on oracle express 11g

1条回答
对你真心纯属浪费
2楼-- · 2019-07-19 11:10

No, the privileges are not inherited (which would be rather problematic when you're joining multiple tables or when you are calling functions). The views are separate objects so the grants are separate as well.

查看更多
登录 后发表回答