How to create connections in Oracle SQL developer

Create User & connections in Oracle SQL developer

You should create at least one database user that you will use to create database objects. Here i created a database connection (ORACLEXE) for the SYSTEM user. Now I am going to create new users under SYSTEM connection.

Here is the steps to follow …

1. Hope you have a database connection for SYSTEM user.
2. Open that connection (Here its ORACLEXE) and Right-click the ‘Other Users’ node in the Connections navigator.
3. Define user name, password, privilages, roles and complete the user creation process.
4. Once you done with user, create a new connection for that user.
5. Give a connection name and configure the user which you just created.
6. Test the connection and make sure the status is ‘Success’.
7. Now we have the connection ready for the user and which can be used as source or target connection in informatica. (See the next post)

 

How to create connections in Oracle SQL developer
Create a new user under SYSTEM (Here its ORACLEXE) connection.
How to create connections in Oracle SQL developer
Give a ‘User Name’ and password for the new User, select default & temporary table space.
How to create connections in Oracle SQL developer
Define Roles for the new user, We have to provide permissions to DBA, CONNECT and RESOURCE
How to create connections in Oracle SQL developer
Select the Quotas as ‘USERS’
How to create connections in Oracle SQL developer
We are done, Apply & Close.
How to create connections in Oracle SQL developer
Now create a new connection for the new User which we just created.
How to create connections in Oracle SQL developer
Give a name for the new connection, give the new USER name & password, select connection type and role. Once done TEST the connection and make sure the status is ‘Success’
How to create connections in Oracle SQL developer
We are done, now you can see a new connection name ‘newuser’ for the user ‘newuser’
How to create connections in Oracle SQL developer
Expand the connection to see other database objects. Now we don’t have any tables in the DB, you can create tables directly writing query here or configure the connection in informatica and use it for source or target tables.

***

If you have any further questions, please do send an e-mail to kvtinformatica@gmail.com.

You May Also Like

About the Author: kvt

Leave a Reply

Your email address will not be published. Required fields are marked *