The security is a very important feature of any table mainly because when there are multiple people that require access. Any of these people may only need access to a specific table to edit the information and placing limitations on this access enables the database manager to maintain better control of any of the sensitive information as well as to ensure that the data is accurate and integrity. I think a class scheduler, for example, would only need access to the table that has the times and the dates for a specific class or classes.

For this person, it is most likely one of the few with information to edit or make accurate changes to the table. Second, if they have a specific job as the schedule, they most likely wouldn’t require access to other tables. Therefore, by closing access to the other tables in the database, it can be definitively distinguished that the information has the altered or changed any of the other information besides from what they have access to.

 

Cite this page

Data Control Language. (2019, Dec 05). Retrieved from https://paperap.com/paper-on-security-and-dml-data-control-language/

Data Control Language
Let’s chat?  We're online 24/7