Create user Oracle Database The sql below is an example of how to create an Oracel database user and grant full permission to create, update, and drop any table.