Security is a major concern for the modern age
systems/network/database administrators. It is natural
for an administrator to worry about hackers and external
attacks while implementing security. But there is more to
it. It is essential to first implement security within
the organization, to make sure right people have access
to the right data. Without these security measures in
place, you might find someone destroying your valuable
data, or selling your company's secrets to your
competitors or someone invading the privacy of others.
Primarily a security plan must identify which users in
the organization can see which data and perform which
activities in the database.
BY: Narayana Vyas Kondreddi
Practicing Security Guidelines and tips gives you security to your database and data.
1. Only gives to MySQL root account the permission to access the user tables.
BY: Narayana Vyas Kondreddi
Practicing Security Guidelines and tips gives you security to your database and data.
1. Only gives to MySQL root account the permission to access the user tables.
2.
You should learn to manipulate MySQL System privilege.
3.
Don’t ever use plain-text password.
4.
Remember your password.
5.
Use fire wall.
6.
Do not
transmit plain (unencrypted) data over the Internet.
7. Install anti-virus software on the SQL Server computer, but exclude your database folders from regular scans. Keep your anti-virus signature files up to date.
8. Restrict physical access to the SQL Server computer. Always lock the server while not in use.
7. Install anti-virus software on the SQL Server computer, but exclude your database folders from regular scans. Keep your anti-virus signature files up to date.
8. Restrict physical access to the SQL Server computer. Always lock the server while not in use.
No comments:
Post a Comment