First ...you are a local...you have far greater chances to get away with the law than an expat because of the double standards with the UAE laws.
But for expats, it is illegal to carry a knife, whether a pocket knife or 15" bowie. knives are allowed only for camping, boating, fishing and hunting as BM posted rightly. not for self defense. It also the stupidest idea to walk to a police station and ask, you will find yourself, questionned for 2 hours as to why you ask, and if you have one.
If you get caught with a knife , or if someone reports you carrying a knife, the least is that you will have to sign an undertaking at the police station and be fingerprinted, they will confiscate your knife and let you go. if you do it again, you will be prosecuted.
Pepper sprays, any self defense items are illegals, as to anything esle which can be used as a weapon, could be a screw driver or stilettos shoes, if they are not yours. handcuffs, scopes, bi pod and such gun accessories are illegal.
You really have no reasons to carry a knife in Dubai .