Create user 权限

17:47:04 SCOTT @ prod > create user scott1 identified by tiger;

create user scott1 identified by tiger

                                 *

ERROR at line 1:

ORA-01031: insufficient privileges

17:47:43 SYS @ prod > select username,privilege from user_sys_privs where privilege like '%USER%';

USERNAME                       PRIVILEGE

------------------------------ ----------------------------------------

SYS                            CREATE USER

SYS                            DROP USER

SYS                            BECOME USER

SYS                            ALTER USER

17:47:45 SYS @ prod > grant create user to scott;

Grant succeeded.

17:48:07 SCOTT @ prod > create user scott1 identified by tiger;

User created.