Secure coding education

block any http request that looks like SQL injection
attack.
usually the first user in the user_table is the root user
timing attack
SQL Map
anytime a sql statement is build by concat strings, it has risk
even valid data can cause injection eg
you can’t parametrize column name and tablename in some languages. you have to validate those names.

every single webpage by default should be treated as auth-required page instead of only validating the pages that should be logged in.
do re-authentication eg in Amazon when the user is going to checkout the shopping cart
re-authentication to prevent session hijacking and CSRF: cross-site scripting attacks,
re-auth before being able to reset password or email.. since email is used to change password
SMS for MFA is easy to get around
login/pwd is not enough
- easily phishable
FIDO standard - the safest since it checks to the hardware. eg. Yubikey
push notifications to auth
The german banks have very effective security policies.
absolute timeout vs idle timeout
in login/pwd auth failure don’t specify what failed
send all usernames over HTTPS
time attacks to see which usernames are good or bad
- to hash passwords
don’t use usernames as public like twitter do. Use your login username and have another that’s the display name
if you lock out an account for brute-forcing, don’t notify them on the website, but send them an email.
do phishing campaign to your own company to detect any weaknesses and to educate.
for single-sign on use OpenId-Connect

hashing is easy decifered with the proper equipment. hashkiller.co.uk , arteschnica.com 6billion passwords per second
encryption - superadmins can decrypt passwords.. so that’s the weakness
salted hash - they will throw an assault of trillion times to the superadmin

scrypt
salt is meant to prevent dedupe attacks, not brute force attacks
a work factor how much work has to be applied to decrypt, that translates into time.
)

delegation framework
OAuth2.0 is token-based
it’s like a valet key - like valet parking key. Has it’s limitations for safety reasons. so you don’t need to giveout your user/pwd.
[not out of the box]federation: to give access from one party to another like with a single-sign-on (eg. GE to Salesforce). Federation gives full power, instead of just a subset of features.
like when an app requests permission to use your twitter account to read your tweets.
be very careful with tokens. and use them only for delegation.
refreshtoken pattern recommended only for social media. refresh_token is like Kerberos ticket `https://en.wikipedia.org/wiki/Kerberos(protocol)`
tokens can be very dangerous, see
https://tools.ietf.org/html/draft-ietf-oauth-v2-threatmodel-08

Training