Description
i. Write command and execute and paste screen shots and make a pdf. You need to show
screen shot to demonstrate the correctness of your code/query.
ii. Submit one file .pdf file containing all answers. The name should be
iii. Write the questions before the answers.
iv. Write a justification of your solution.
v. The code should be executable and show output.
____________________________________________________________________________
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.
