ORA-01932 option is not authorized for role ' CONNECT '

When the SYS user is logged in:

Create user Tony identified by 123;

Grant connect to Tony;

Then Tony User login:

Create user jinge identified by 123;

Grant connect to Jinge;

This time the prompt ORA-01932 option is not authorized to the role ' CONNECT '

With admin option is used for system permission authorization, with GRANT option for object authorization.

Grant system permissions to a user with admin option, this user can grant this system permission to another user or role, but when the user's system permissions are retracted, the system permissions that the user has granted to other users or roles are not invalidated by propagation, such as granting a system permission to create Session with admin option, then a gives the Create session permission to B, but when the administrator reclaims A's create session permission, B still has the Create session permission, However, an administrator can explicitly retract the permissions of the B create session, that is, directly revoke create session from B.

When the WITH GRANT option is used for object authorization, the granted user can also grant the object permissions to other users or roles, except that when the administrator reclaims the user object permissions granted with GRANT option, the permissions are invalidated by propagation, such as Grant Select on Table with GRANT option to a,a the user grants this permission to B, but when an administrator reclaims A's permissions, B's permissions are invalidated, but the administrator cannot directly retract the Select on TABLE permission for B.

Alter user Jinge identified by 111;

insufficient prompt authority;

Reference: http://blog.csdn.net/robinson_0612/article/details/5989565

SYS: Super User

System: In addition to the inability to complete backup recovery, and all database management beyond upgrades

But all two are DBA roles

SELECT * from V$pwfile_users;

SYS user grant create public synonym to Scott;

SELECT * from User_sys_privs;

No hint, but not authorized to succeed;

Reference: http://www.itpub.net/thread-991487-1-1.html