If you want to specify a database login name other than the system login name, you can use configured login. The SQL command syntax to enroll a new user by configured login is:
GRANT CONNECT, RESOURCE TO db_login_name IDENTIFIED BY
password
where db_login_name is the name you want to use to log in to the database.
For more details on login, see your site's DBA and the Oracle Database Administrator's Guide.