More Subjects
Security and DML (Insert, update and delete)
[Name of the Writer]
[Name of the Institution]
Security and DML (Insert, update and delete)
A class scheduler can be limited to access a specific table or database using Grant statement in the Oracle database. Grant statement is used to assign system privileges to users. A user must be assigned the role with ‘admin option' statement or should be assigned the ‘grant any role' system privilege or create a role manually for the access to database or table. Roles are very useful in granting the roles that contain only the privileges according to the requirements of the user. The user can choose the selective availability of privileges for users which will allow specific control of user privileges for a database. A class scheduler will be given the privilege to select any table which means he/she can only view the data in the Oracle database. Database administrators are usually responsible for assigning the roles of the users to enhance the security of the system.
There are two login methods in the Oracle database. The two login methods include the old password and secure password method. In this situation, a class scheduler can only view the student information so for that I will prefer the secure password method because it is more secure as compared to the old password method. In the old password authentication method, client-side requires 8-byte random challenge from the server, and insecure password authentication method, and client-side requires 20-byte random challenge from the server. The old password authentication method is not secure as compared to the secure password authentication method because the secure password method uses a tested cryptographic hashing function which isn't broken. The old password allows users to enter into the database using the authentication method name which is the old password of MySQL. So in this case, a secure password authentication method will be used to give access only to the student's information table.
More Subjects
Join our mailing list
© All Rights Reserved 2024