Suppose the following sequence of GRANT commands are executed:

philip issues the command: GRANT SELECT ON staff TO alice WITH GRANT OPTION

alice issues the command: GRANT SELECT ON philip.staff TO vicky

philip then issues the command: REVOKE ALL on staff FROM alice

Which of the following is true?

Select one answer.

Question

Suppose the following sequence of GRANT commands are executed:

philip issues the command: GRANT SELECT ON staff TO alice WITH GRANT OPTION

alice issues the command: GRANT SELECT ON philip.staff TO vicky

philip then issues the command: REVOKE ALL on staff FROM alice

Which of the following is true?

Select one answer.

BlackTom AI · Accepted Answer

The question presents a sequence of GRANT and REVOKE commands and asks which statement remains true.

First, examine the initial grant: GRANT SELECT ON staff TO alice WITH GRANT OPTION. This gives alice the ability to SELECT from staff and, crucially, the power to grant that same privilege to others (grant option).

Next, alice grants SELECT ON philip.staff TO vicky. This action creates a privilege for Vicky to SELECT from philip.staff. Note that this grant is on a different object (philip.staff) than the first grant (staff), and it did not include WITH GRANT OPTION, so Vicky cannot further grant this privilege to others.

Then, philip issues REVOKE ALL on staff FROM alice. This revokes all of alice’s privileges on the staff object. In other words, alice loses her access to staff and, importantly, loses her ability to grant privileges on staff in the future. Crucially, this revocation targets the staff object and alice’s privileges on that object specifically; it does not automatically revoke privileges that alice has granted on a different object to other users.

Consider the privilege granted to vicky: it was granted by alice, but on philip.staff. Even though alice’s privileges on staff have been revoked, vicky’s permission on philip.staff remains in effect unless the grant is explicitly revoked. Since vicky’s grant did not indicate WITH GRANT OPTION, and the revocation was not described as cascading to philip.staff, there is no automatic chain that would remove vicky’s privilege from philip.staff.

Therefore, vicky retains the ability to perform SELECT on philip.staff, assuming no later revocation targeted that specific privilege.

In summary, the revoke on staff affects alice’s access to staff, not the privilege she granted to vicky on philip.staff, so the remaining true statement concerns vicky’s continued SELECT capability on philip.staff. The provided option reflects that outcome: vicky can run SELECT statements on philip.staff.

G6031: Databases Databases Assessment Part 1

View Explanation

Log in for full answers

Similar Questions

In the context of SQL, what does the READ ONLY access mode allow?

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

Under the assumptions used in cost-volume-profit analysis, as the activity increases:

The CVP and break-even analysis are supported by a range of important assumptions. Which of the following is not an assumption of the CVP:

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler