University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2023
Views:

457

Pages:

1
Author:

Muthia M.

Data Protection Measures A. Database Backup Database backup is the process of creating, managing, and storing copies of data in case it's lost, corrupted, or damaged. A database backup is a solution for safeguarding structured data found within database workloads. Ideally, it should provide comprehensive coverage for hybrid environments, as organizations need to ensure the backup and recovery of their data in both on-premises and cloud settings. B. Restoring Restoring is the process of copying data from a backup and applying logged transactions to the data. When you want to fully restore a database, you start by restoring a full backup of the database. If you have one, you can also restore a differential backup. After that, you go on to restore all the log backups that came after in the correct order. Finally, you complete the database restore by recovering the latest log backup and restoring it using the "RESTORE WITH RECOVERY" command. Some command to do protection database are: 1. GRANT: This is a SQL command which is used to provide privileges/permissions to modify and retrieve database objects like tables, views, sequences, indexes, an synonyms. 2. REVOKE: is used to revoke or withdraw permissions that were previously granted to an account on a database object. 3. WITH GRANT: The difference between these options is very simple. In case of only GRANT, the username cannot grant the same permission to other users. On the other hand, with the option WITH GRANT, the username will be able to give the permission after receiving requests from other users. 4. PoLP: The principle of least privilege (PoLP) is an information security concept which maintains that a user or entity should only have access to the specific data, resources and applications needed to complete a required task. C. Purpose of Roles A role is a collection of privileges that can be granted to one or more users or other roles. Roles help you grant and manage sets of privileges for various categories of users, rather than grant those privileges to each user individually.