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 t
Solution 1:
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.
Post a Comment for "Are The Privileges On Underlying Table Automatically Passed On To Any Views Created On The Table?"