However, if the drugs are reasonably benign despite being prescription, and the amount you're bringing in is small, CBSA has been known to turn a blind eye to it.
People do bring in a couple of strips (20-30 pills) of low level antibiotics, stomach medication, blood pressure pills etc. If caught, the pills will be taken away from them but they are unlikely to face any real punishment.
It's still illegal though and I would counsel you to follow the law.
Practically speaking I know it's different, but if you try bringing in 100 sleeping pills and you get sent to jail, you can't say that other people were allowed.
Do what you will with the information.