To create an Oracle user, the administrator must have CREATE USER, ALTER USER, and DROP USER system privileges.
For Oracle and Oracle Applications, administrators must have SELECT permissions on the following database views:
DBA_PROFILES
DBA_ROLE_PRIVS
DBA_SYS_PRIVS
DBA_TABLESPACES
DBA_TS_QUOTAS
DBA_USERS