What all privileges your user has? can u list them to us. To create new User, one needs CREATE USER system privileges. Also the tablespace you are specifying for the user should exists.
Check dba_sys_privs, and dba_tablespaces for more information for the user who is trying to create new users.




Reply With Quote