1. with admin option是用在系统权限上的,with grant option是用在对象权限上的。
SQL> grant create synonym to scott with grant option;grant create synonym to scott with grant option ...
The Tk command option acts on the "option database".
[option add] pattern value ?priority? [option clear] option get window name class [option readfile] fileName ?priority?
...
相同点:- 两个都可以既可以赋予user 权限时使用,也可以在赋予role 时用GRANT CREATE SESSION TO emi WITH ADMIN OPTION;GRANT CREATE SESSION TO role WITH ADMIN OPTION;GRANT role1 to role2 WITH ADMIN OPTION;...
Canvas
Option name
.Xdefault's name
Class name
Default value
Current value
-activegroup
activeGroup
ActiveGroup
0
undef
-background
background
Background
#d9d9d9
#d9d9d9 ...
下面这篇文章关于with admin option、with grant option的介绍,比较清晰明确;
参考文章:http://hi.baidu.com/whiteprincer/item/77e5bd901d5590be82d295d2
with admin option是用在系统权限上的,with grant o...