All Forums Database
barani_sachin 141 posts Joined 01/12
19 Feb 2014
EXEC Privilege & Table access?

Hi All,
     Lets say user1 has access to Execute macros but  in one of the macro there were two tables referenced and he doesnt have access to those two tables. Will he still be able to execute the macro and get the desired results or will it error out?
PS: I dont have access to create a macro in my Test environment.

Adeel Chaudhry 773 posts Joined 04/08
19 Feb 2014

Yes, the database in which that Macro resides should have access to the underlying tables. Without which you cant compile a Macro. And all you need is the right to execute Macro to get the desired results.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.