|
When people use funny characters in their password my code doesn't work
string sql = "insert into users (username, password) values ('" + TextBox19.Text + "', '" + TextBox6.Text + "')";
How can I stop users using funny characters?
|
|
|
|
|
I think you may have just explained the problem. 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I had a client insist I add password protection to an innocuous app in case somebody walked by and decided to access the data on an unattended machine.
I suggested they put a password on their windows as they had other apps (including main accounting) and files without passwords, also mentioned it acts as line of defense for external attacks - plus it was already built-in ans even better free of charge.
He told me "that would be too hard for them to remember."
Duly added the password requirement as requested, and of course walking around the office during lunch lots of PC's sitting there, windows [and often other apps] open, (and almost always the customary post-it note on the edge of the screen with the app password.) 
Anyway, nice bit of extra work; why argue if they give me more money to support their own stupidity.
Sin tack ear lol
Pressing the "Any" key may be continuate
|
|
|
|
|
Lopatir wrote: He told me "that would be too hard for them to remember."
 Believe it or not our company has been doing a lot of that stupid stuff lately. Making poor decisions just because they believe the end user is too stupid. It's driving me nuts. 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Because they want you to read your password over the phone to one of their support drones, and "special" characters make that harder to do?
Because their code is vulnerable to SQLi, and they don't want you to enter a password of Robert'); DROP TABLE Students;--?
If you ask them, they'll probably tell you it's to increase the security of the site, and they'd lose their certification if they removed the restriction. (Don't bother asking what certification; they won't be able to tell you.)
That'll also be the reason why they don't let you paste your password from a password manager; why they restrict the password to a maximum of 8 characters; and why the password isn't case-sensitive. 
Whatever the reason, it suggests they're not handling and storing your data properly, and you should probably avoid using that site. If you can't avoid it, make sure you use a unique password that you don't use on any other site, because it's almost certainly going to be stored in plain text. And if at all possible, avoid giving them any personal information, since it's going to end up on a "pastebin" dump before long.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
All my passwords are based on a special secret alphabet that I crafted in my voodoo laboratory. Just saying...
|
|
|
|
|
Just a few weeks ago a new password was rejected because it contained a - (hex 2D). Using an underscore was OK.
So, yes I noticed it (and thought WTF).
Maybe the passwords has to be piped between shell commands, then passed as shell command parameters, HTML/XML encoded and decoded, and finally passed to a SQL query. To avoid escaping all the processing specific reserved characters using processing specific escaping it is just simpler to disallow them.
|
|
|
|
|
You forgot the "signed in triplicate, sent in, sent back, queried, lost, found, subjected to public inquiry, lost again, and finally buried in soft peat for three months and recycled as firelighters" part. Sadly many sites are "managed" just like that.
DURA LEX, SED LEX
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
When I was six, there were no ones and zeroes - only zeroes. And not all of them worked. -- Ravi Bhavnani
|
|
|
|
|
+1 for the HHGTTG reference.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
If their website cannot handle unicode passwords, they certainly deserve to have their computer nerd card revoked.
if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
|
|
|
|
|
It's easier to crack a$&12Gc# than to crack donalduckwasmyfavcharacterasakidinnewyork.
|
|
|
|
|
Nish Nishant wrote: It's easier to crack donalduckwasmyfavcharacterasakidinnewyork than to crack donalduckwasmyfavcharacterasakidinnewyork!.
FTFY 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Yeah but a day's difference won't affect something that'd take weeks or months of computational power 
|
|
|
|
|
In that case, "It's as easy to crack a$&12Gc# as abd12Gc4", so why prevent special characters?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I guess they are trying to encourage people to use passwords that are hard to crack but easy to remember, so they don't write it down on a piece of paper and stick it on their screens.
I am not siding with that idea, and would personally not enforce this rule at my work place. Just trying to guess what their thinking was.
|
|
|
|
|
Possibly.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
The only secure password is one you can't remember.
Seriously, don't try to remember all your passwords; use a password manager. Then you'll only need to remember one master password, and protect the password manager storage.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
People who are multi-lingual have an advantage - they can create cryptically complex passwords that they can easily remember by mixing languages.
Example : thendralbaarishseason
I've mixed a tamil word, a hindi word, and an english word there. What's gibberish to most mono-lingual people is a very easy to remember word for me (I speak 4 languages).
|
|
|
|
|
A-Z, lowercase only, no symbols, no digits.
Methinks your password would be easier to crack than you might think.
|
|
|
|
|
dandy72 wrote: A-Z, lowercase only, no symbols, no digits.
Methinks your password would be easier to crack than you might think.
Trivial to introduce a few upper case letters. My point was that it's more complex than had I used English only words for the same length. Also even with lower case, a 25 length string is harder to crack than a 10 char password that uses both cases, numbers, and symbols.
|
|
|
|
|
Nish Nishant wrote: 25 length string is harder to crack than a 10 char password that uses both cases, numbers, and symbols.
Are you sure about that?
A 25-character password * a pool of (26 possible characters) can be brute-forced in 650 tries.
A 10-character password * a pool of (26 upper + 26 lower + 10 digits + ~20 symbols) require 820 tries to be guessed correctly.
Having written this...I'm tired and my mind has turned to mush a few hours ago and this looks wrong (I know exponentials have to be introduced in there), but even then I think the basic point of my over-simplification is still correct...is it not?
I'm sure the correct math will come to me after I've made a fool of myself...
|
|
|
|
|
dandy72 wrote:
Having written this...I'm tired and my mind has turned to mush a few hours ago and this looks wrong (I know exponentials have to be introduced in there), but even then I think the basic point of my over-simplification is still correct...is it not?
Sorry, your math's not right
A char-set of 26 chars with a length of 25 gives 2.36e+35 permutations.
A char-set of 82 chars with a length of 10 gives 1.37e+19 permutations.
The former is way stronger
|
|
|
|
|
Nish Nishant wrote: Sorry, your math's not right 
Hence the disclaimer.
I knew I was way off, and somebody would correct me. Was not disappointed.
|
|
|
|
|
To get back to my original point, what I am trying to convey here is that a longer easier to remember password is often safer than a shorter harder to remember one. That said, it's not all black and white.
|
|
|
|
|
Agreed. Horse-Battery-Staple and all that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
