Why is that even if a user does not have required rights on tables under lying in a macro can execute the macro if the user has execute right on that macro?
Why is that even if a user does not have insert rights on a table under lying in a view can insert rows through that view if the user has insert rights on that view?
In both of the above scenarios, how actually the rights will work??
If the user is allowed those operations then it means that the owner of the view or marco has both the appropriate rights on the underlying table and WITH GRANT OPTION to be able to pass those rights on the user of the view or macro.