You execute the following set of commands to create a database user and to grant the system privileges in your production environment SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE