using TD release 14.10.07.01
I create a simple macro named "table_att" .
If i execute it with DBC it works fine, but if some other user try to execute it obtains the error :
"EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>"
The user I use to chech it is "franc" , with role "rl_franc" , the role has all grants for the db where my macro is defined "db_macro".
But if I grant the user "franc" , instead of the role , all gone right.
Can someone explain that ?
Solved! Go to Solution.
Thank you for the answer.
You were right, the user had no active role. I granted the right role to the user and now all works fine.