oracle Oracle中的ADMIN选项和GRANT选项有什么区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21606405/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the difference between the ADMIN option and the GRANT option in Oracle
提问by Paul J Abernathy
I am studying SQL syntax for Oracle and have come across both an ADMIN option and a GRANT option for giving users the ability to grant privileges. For example, if I want to give the SELECT privilege to user SCOTT on HR's EMPLOYEES table and give the ability to grant that access to someone else, I might do
我正在研究 Oracle 的 SQL 语法，并且遇到了 ADMIN 选项和 GRANT 选项，用于授予用户授予权限的能力。例如，如果我想将 SELECT 权限授予 HR 的 EMPLOYEES 表上的用户 SCOTT，并将该访问权限授予其他人，我可能会这样做
GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH ADMIN OPTION
or
或者
GRANT SELECT ON HR.EMPLOYEES TO SCOTT WITH GRANT OPTION.
It seems either is supposed to work. Does anybody know what the difference is?
似乎两者都应该起作用。有人知道有什么区别吗？
采纳答案by zee
Read This
读这个
Both the “with grant” and “with admin” options serve to relinquish central security control, but they are for different types of privileges.
“with grant”和“with admin”选项都用于放弃中央安全控制，但它们用于不同类型的权限。
With Grant option:
使用授予选项：
Only for object privileges, not system privileges.
Only the person who granted the privilege can revoke the privilege.
Revoked privileges can "cascade", allowing the first grantor to revoke many
subsequent grants.
仅适用于对象权限，不适用于系统权限。
只有授予特权的人才能撤销特权。
撤销的权限可以“级联”，允许第一个授予者撤销许多
后续授予。
With Admin option:
使用管理员选项：
- Only for system privileges, not object privileges.
- 仅适用于系统权限，不适用于对象权限。
