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?

Name the Supreme Court decision that removed financial constraints on PACs.

Political scientists Joshua Kalla and David Broockman find that senior policy makers made themselves available to _____ between three and four times more often than they did to constituents.

Name the political scientist who argues that parties are designed to serve the needs of ambitious politicians (namely candidates and officeholders).

Name the political scientist who said this famous quote about the problems of pluralism: “The flaw in the pluralist heaven is that the heavenly choir sings with a strong upper-class accent.”

What is the name of the third party candidate in 2000 who was not allowed to participate in the presidential debates? Hint: We watched a video clip with him in class.

E.E. Schattshneider said, "Democracy is ________ save in terms of the parties."

Who was the most recently appointed justice to the Supreme Court?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单