Use with admin option and with GRANT option

1. With admin option
with admin option means that the user granted the permission has the right to grant a permission (such as create any table) to another user or role, and the cancellation is not cascading.
If you grant a system permission to create session with admin option, and then a CREATE session permission is granted to B, but the administrator reclaims the Create session permission for a, B still has the Create The permissions of the session. However, the administrator can explicitly retract the permissions of the B create session, i.e. directly revoke the create session from B.

2. With GRANT OPTION
With grant option means that a permission grant/cancellation is cascaded, such as when using with GRANT option for an object authorization, the granted user may delegate this object permission to another user or role, except that the administrator withdraws the WITH grant option authorizes the User object permission, the permission is invalidated by propagation, such as grant Select on table with the grant option to a,a the user grants this permission to B, but the permissions of B are invalidated when the administrator reclaims the permissions of a. However, the administrator may not directly retract the Select on TABLE permission for B.

Use with admin option and with GRANT option