help!

[复制链接]
查看11 | 回复4 | 2010-3-1 11:06:22 | 显示全部楼层 |阅读模式
The HR user owns the EMP table. The HR user grants privileges to the SCOTT user by using this command:
SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;
The SCOTT user executes this command to grant privileges to the JIM user:
SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;
Now the HR user decides to revoke privileges from JIM by using this command:
SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim;
Which statement is true after HR issues the REVOKE command?
回复

使用道具 举报

千问 | 2010-3-1 11:06:22 | 显示全部楼层
Where are the statements?
原帖由 gy1982329 于 2008-4-5 20:21 发表
The HR user owns the EMP table. The HR user grants privileges to the SCOTT user by using this command:
SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION;
The SCOTT user executes this command to grant privileges to the JIM user:
SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;
Now the HR user decides to revoke privileges from JIM by using this command:
SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim;
Which statement is true after HR issues the REVOKE command?

回复

使用道具 举报

千问 | 2010-3-1 11:06:22 | 显示全部楼层
权限进行了传递
hr不能直接对JIM revoke,hr要想收回由soctt授予JIM的权限,需要执行
revoke select , insert , update from soctt,这样scott也会自动回收授予JIM的权限
对象权限可以cascade回收,而系统权限不能cascade回收
回复

使用道具 举报

千问 | 2010-3-1 11:06:22 | 显示全部楼层
lz,没有可供选择的statement:)
回复

使用道具 举报

千问 | 2010-3-1 11:06:22 | 显示全部楼层
lz,没有可供选择的statement:)
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行