Instead of using shared logon in connection pool. we need to use dynamic user password/user PAT (OAuth) to connect database whenever user runs dashboard/report first time. so that data security would applicable based on user access at DB side.
In current scenario by using RPD connection pool (shared user/password) we are not aware which user is trying to access database/data
Eg: we have already implemented data level security for user at DB side which is using for multiple applications. We do not want to put additional effort or having separate security mechanism at OAS side. we want to use existing DB security model for OAS
