CODEWITHSUNDEEP
sqldatabaseoracle-databasesecurity
RSK
RSK

Reputation: 2221

Are the privileges on underlying table automatically passed on to any views created on the table?

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

Upvotes: 2

Views: 203

Answers (1)

Justin Cave
Justin Cave

Reputation: 231691

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.

Upvotes: 6

Related Questions