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)

 

Create a new user under SYSTEM (Here its ORACLEXE) connection.
Give a ‘User Name’ and password for the new User, select default & temporary table space.
Define Roles for the new user, We have to provide permissions to DBA, CONNECT and RESOURCE
Select the Quotas as ‘USERS’
We are done, Apply & Close.
Now create a new connection for the new User which we just created.
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’
We are done, now you can see a new connection name ‘newuser’ for the user ‘newuser’
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.

Related Posts:

Leave a comment

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