Description
A. Demonstrate Rollback and Commit on Student table of University Database. (Show at least 2 examples for both Rollback and Commit ) [1] B. Create a user and do the following on ‘Student’ Table:- [1] a. Login as User and use ‘SELECT’. b. Grant Select permission to the user. c. Now again try using ‘SELECT’ as a user. d. Give update permission to the user e. Try using ‘UPDATE’ as a user. f. Drop the user. C. Use Role to solve the tasks given in Q2. [1] D. Do the following tasks:- [2] a. Create a user ‘abc’ and grant all permissions to it. b. Login as ‘abc’ and create another user ‘def’. c. User ‘abc’ will assign permissions to ‘def’ to view and update data of student table. d. Login as ‘def’ and use the permissions given to ‘def’ e. Drop user ‘abc’ f. Login as ‘def’ and check if it have the permissions specified or not. Justify your answer. g. Drop user ‘def’. h. Create user ‘def’ and check if it have the permissions specified or not.