Hello @surajthakur 
Thanks again for reaching out to us!
As per Michelles’ testing above (also confirmed with my own testing) - should those two roles be made previous - filling the two roles into the Secret Manager secret’s resource permissions should do what you’ve described (after they each have been created the first time round in Stack creation).
Cheers - please let us know how it goes 
James