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.

类似问题

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

Which ONE of the following thalamic nuclei is targeted by the trigeminothalamic tract?

Which ONE of the following is disinhibited in the direct pathway of the basal ganglia motor loop

30. What is the main purpose of the lecture?

Section FChoose a, b or c as the best answer.29. Which statement is the speaker most likely to agree with?

28. 15-minute neighbourhoods provide residents with inexpensive ____ .

27. ____ % of global car ownership is in the U.S.A.

26. ____ % of American drivers use their cars for all journeys.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单