Note: You will probably need database administrator privileges to perform the following action.
If you want to specify a database login name other than the system login name, you can grant it the necessary privileges using
the following SQL syntax, when connected to the database:
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.