Configure SQL Developer in Windows 8/8.1 [WORKING]

Steps:

  1. Install Oracle 11g database software (download).
  2. Install SQL developer software (download).
  3. Now run sql command line and insert following code:
    • First we need to create a new user and grant it privileges to access database.
      •  connect / as sysdba
      • create user <user_name> identified by <password>;
      • grant create session to <user_name>;
      • grant unlimited tablespace to <user_name>;
      • grant all privileges to <user_name>;
    • Once user is created and all privileges are granted successfully. Open SQL developer and connect to your database as the user. Configuration is shown in the picture below.
    • Enjoy!
sql command line, creating user.

sql command line, creating user.

Configuring SQL developer

Configuring SQL developer

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s