Most front end employees do not know that federal regulations supersede their authority. Politely ask to see a manager.

Pharmacies are regulated by the FDA (for now anyway. Who knows what things will look like a month from now) and pharmacies cannot bar customers from using their services.

Edit: Here is the official Costco policy