Importance of Database Security

Database security is highly important because it prevents data loss, leakage, or unauthorized access to sensitive data. A few of many ways to secure a database is by making sure the hosting machine is housed, secured, locked and monitored to prevent unauthorized entry, access or theft. Apart from physical security the database should have firewalls implemented with default rules to deny all traffic, only opened to specific applications or web servers.

User database roles and management is another security need of a database system. This implements access to only authorized users, and minimal permissions are given to each job function. Database backup and recovery is another important piece of database security. This prevents data loss keeping a copy of the database when in need. Keeping backup and recovery procedures documented and periodically is a good practice. Another security need of a database is encryption and key management, allowing data to be encrypted during transmission over the network, minimizing data exposure if intercepted or misrouted.

Sources:

https://security.berkeley.edu/resources/best-practices-how-articles/database-hardening-best-practices

https://docs.oracle.com/cd/A58617_01/server.804/a58396/ch1.htm

Comments

The use of libraries are an important part of coding.

A library in programming code is a collection of similar objects that are stored for occasional use. It is a collection of reusable and precompiled programming routines that the programmer can "call" when writing code so that the programmer can just use and not have to write it. Frameworks are reusable software environments that provide functionality to facilitate development of software applications, products and solutions. They can include compilers, code libraries, tool sets and application program interfaces to help the development of projects and solutions. A namespace are structured hierarchies that serve to allow the reuse of different names in different contexts, and have a purpose of avoiding name collisions between multiple identifiers that share the same name. A class is like a blueprint, it is basically set of instructions that define how an object looks and its specifications, they can store things and do things. Finally method is a series of statements that ...

WHILE and IF statements

A while loop statement will repeatedly execute a statement as long as the given condition is true. If the while loop's condition is set to true then the program will go into the loop, and will keep looping as long as that condition remains true. For example: int score = 15; while (score < 20) { Console.WriteLine("value of score: {0}"), score; score++; } Console.ReadLine(); In this example the program will go into the loop for as long as the value of score is less than 20. Once it's in the loop it will increment the value of score by one, then it will check if a is still less than 20. Once the value of score reaches 20, it will no longer go into the loop as the condition will no longer ...

MATC Event Planner Project

In my IT Project management class I had to work with team mates to create a project that we could essentially propose in the real world. The project we created was an event planner that MATC organizations could use to create events, since there is no streamlined system in place today. During this process I learned the different methodologies that people can use to create and successfully develop a project. The time I spent in creating and working with my team in this project has taught me the importance of planning a project instead of jumping into it right away. Here is the link to my final project's proposal document: Project Proposal Project Presentation

IT Dominoe

Search This Blog