DevOps, CI/CD and Automation

I am novice with Oracle, but pretty good with ASP.NET.
I am creating an asp.net web application. I had originally planned to set up a user database like the asp.net membership provider.
I have now found out that the powers that be want the website logins to use actual oracle database logins to connect from the web app.
This is totally new to me, I am used to setting up a connection string in .net and using one database user to connect to the database.

Then someone would login via a membership provider users.

How can i set up my .net site to use actual database login and not logins from a membership provider.

thanks I hope i explained my question well enough.