Using Static and Dynamic Secrets together for Same Database in Application

Hi,

I am required to use vault static and dynamic secrets together based on the condition in my application. I want to use dynamic credentials for specific requests in my application and static credentials for the rest of the requests.
please guide me if this is possible to use multiple roles of vault in our application.