Reference no: EM133517724

Question  1. Write the statements to create a role called exam_user and assign permissions to select and delete on student table. Give this role to the account TestUser.

Question 2. write a statement to enable a role of 'hr_clerk' with password 'student'.

Question  3. Write the statement that enables you to audit select statements on Student table.

Question  4. Write the statement that will be used to audit update statements issued by the users 'Student_usert' and 'Student_user_2' on student table.

Question  5. Write the statement that will create a function based index for 'student_last_name' column in Student table using function lower(). Give the index name as 'student_name_indx'.

Question 6. Create a log table for keeping the logs of the changes made in the si.customer table and write a trigger that would write all data changes to that log table.