How to pass dynamic values on the fly to CDS in SAP ABAP

I don’t think that there exists a way where you can pass dynamic values to the CDS.

In order for DCL to do its assigned activity you need to declare and define the authority object. Let’s say you cannot do this. Then you can get all the results and then filter the results at Gateway layer using ABAP.