EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>

Analytics
Fan

EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>

Hello

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".

grant.JPG

 

 

 

 

 

 

 

 

But if I grant the user "franc" , instead of the role , all gone right.

 

Can someone explain that ?

 

Thank you.

 


Accepted Solutions
Senior Apprentice

Re: EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>

Is the ROLE actually active, i.e. does SELECT ROLE return either rl_franc or ALL?

1 ACCEPTED SOLUTION
2 REPLIES
Senior Apprentice

Re: EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>

Is the ROLE actually active, i.e. does SELECT ROLE return either rl_franc or ALL?

Fan

Re: EXECUTE Failed. 3523: The user does not have EXECUTE access to <mocro_name>

Hello dnoeth.

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.