SQL Developer has a very convenient function which allow users to create database users with user interface. Before you can create you need to ensure you have enough privilege. i.e.,CREATE USER, ALTER USER and etc system privileges.

If you don’t have enough privileges to create user, you may find the tablespaces option are blank and you cannot choose the any existing tablespace as default tablespace.

Before you click apply to create the user, you can also extract the SQL statements for the user options that you have chosen.

Move the results tab and then click Apply button. The SQL Developer will create user for you and you can see whether the user is created successfully and any error encountered during user creation will be shown as well.