Rights on View and macro and underlying tables

Database
Enthusiast

Rights on View and macro and underlying tables

Hi All,

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??

2 REPLIES
Enthusiast

Re: Rights on View and macro and underlying tables

Hi,

Could anyone answer to my doubt ?

Teradata Employee

Re: Rights on View and macro and underlying tables

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.