Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q: 6 Assume that user A 1 is the owner of the Dept table ( ie . User A 1 has full control on table

Q:6 Assume that user A1 is the owner of the Dept table (ie. User A1 has full control on table Dept.). Consider the following Grant statements: User A1 issues: Grant Select, Delete, Update on dept. to A2 with grant option User A2 issues: Grant Select, Update on Dept. to A3 User A2 issues: Grant delete on Dept. to A4 For each of the following SQL statements, indicate whether the statement is legal fi.e. respects the privileges defined above) or illegal (does not respect the privileges defined above). Statement Legal Yes or No? User A4: Delete from Dept where dept-no =10; User A4: Select * from dept; User A2: Update dept set location = "Doha' where dept-no=20 User A1: Create view V1 as select * from dept where dept-no=10 User A3: Select * from dept;

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

Databases Theory And Applications 27th Australasian Database Conference Adc 20 Sydney Nsw September 28 29 20 Proceedings Lncs 9877

Authors: Muhammad Aamir Cheema ,Wenjie Zhang ,Lijun Chang

1st Edition

3319469215, 978-3319469218

More Books

Students also viewed these Databases questions