[Q] a sts question

显示全部楼层 · 2005-10-30 17:05:33

User SNOW owns table SALES , and she grants delete privileges to user REED using
the with grant opton clause , REED then grants delete privileges on SALES to MANN.
SNOW discovers MANN has the privilege and revokes it from REED , Which of the following
users can delete date from the SALES table?
A, SNOW MANN
B, MANN
C,REED MANN
D, SNOW
BOOK ANSWER :d
我觉得是a

千问 · 2005-10-30 17:05:33

D,
When a privilege is grant by GRANT option by top level grantor and the grantee's privilegeis revoked by top level grantor later, then all low level grantee's privlege will be revoked.

千问 · 2005-10-30 17:05:33

grant create session with admin option 子句
reed to mnaa , mnaa to snow
user :reed----mnaa---snow
当 reed收回mnaa 权限后，snow 没被收回

千问 · 2005-10-30 17:05:33

Revoking object privileges will also cascade when given WITH GRANT OPTION.
see SG 16-21

千问 · 2005-10-30 17:05:33

so the answer d is Right