Answered step by step
Verified Expert Solution
Link Copied!

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'

image

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions