Security and Performance – issues and solutions
Security, not just in SQL but in any computer language, refers to protecting the data stored in the database. This data contain a lot of information about the products, suppliers, employees, customers, such as personal data, payment methods – credit/debit cards details, bank accounts details and many more. We need to make sure that only authorized personnel have access to this information and of course we cannot grand a universe access to any user, so we must restrict the users to have access only to the bits of …show more content…
Creating a strong password is a piece of art literally. Some main rules must be followed if you want your password to survive the hard hit of the hacker. The password must be:
• Different from the username
• Not a dictionary word
• 10+ characters length (about this subject some of the specialist believe that 8 characters are more than enough for a strong password)
• To be included at least one letter, one number and one special symbol like “\ - . , ! = + * ?” etc.
Many websites require a lowercase letter and uppercase letter. In fact this does not make any difference, because the script breaking down the password is not keys sensitive, and why it will be? By my opinion this is marketing strategy created to make the regular user filling more secure, and this way the website is gaining more trust and recommendations.
Or you can lock them
ALTER USER user_name ACCOUNT LOCK;
To unlock the user we must replace 'lock' with 'unlock'.
It may look like a small issue, but it may cost you the database if you are not