Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Following Question contains multiple parts. Make sure to answer all the Questions by marking answer with correct part number. 1. Creates users named 'mainuser'
Following Question contains multiple parts. Make sure to answer all the Questions by marking answer with correct part number. 1. Creates users named 'mainuser' with password 'Secret! (1 Mark) 2. Create another user 'otheruser' with password 'Secret2. (1 Mark). 3. Change password for 'otheruser' to 'trythis'.(1 Mark) 4. Give privileges to both users so that they can connect. (1 Mark). 5. Give table creation privileges to 'mainuser'. in such a way that 'mainuser' should be able to give these privileges to others. (1 Marks) 6. Connect as mainuser. (1 Mark) 7. Create table Persons with Person_id of type number, person_name of type varchar2. (1 Marks) 8. Assign a privilege to insert data into person_name column and perform select queries on Persons table to otheruser. (1 Marks) 9. Connect as dba again and Revoke create table privilege given to mainuser. (1 Mark) 10. Drop the otheruser created above. (1 Marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started