Helpful Oracle hints I've found and saved

Creating Users in SQL Developer

I tend to prefer using SQL commands to create and update things in Oracle. I'm not sure why, maybe it just makes me feel like I actually know what's being done when something happens.

You could create a User object in Oracle using an SQL query like the following:

CREATE USER "THE_USER_ID"  PROFILE "DEFAULT"
IDENTIFIED BY "THE_PASSWORD" DEFAULT TABLESPACE "THE_TABLESPACE"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED
ON "SOME_OTHER_TABLESPACE"
ACCOUNT UNLOCK;

But, sometimes, it makes sense to use a GUI tool to do something when you don't feel like hunting down the query that you can't remember off hand ;-).

It's not immediately obvious how to create a user in SQL Developer, so here's a quick guide:

1- Connect to your database and expand the connection tree:

2- Right-click on the "Other Users" Node:

3- Click on "Create User…" and go wild.

🙂

And THAT'S how you create a new Database User in Oracle using SQL Developer

6 Responses to “Creating Users in SQL Developer”

  1. Ramesh V says:

    Hi,

    Thanks a lot. I had searched for this tip (creation with GUI)for quite sometime

    Ramesh

  2. Cristy Lovely Escorial says:

    what if i can't create users because of insufficient privileges? what should i do?

  3. Vijaykumar says:

    Hi, I am having already installed 10g XE version in my system.i know one user and password to connect. when i launch home page i am getting IE cann't display the webpage error. so i tried to reset the password for sys or system it throwed me error insuficent previlages.

    so can someone tell me what do? i want to reset the password or see what is the default password.

Trackbacks/Pingbacks

  1. ACA IT-Solutions Blogs - [...] When this configuration completes successfully you should be able to tunnel the database listener port, 1521, to your local…

Leave a Reply to Cristy Lovely Escorial Cancel reply

Powered by WordPress | Designed by Elegant Themes

Pin It on Pinterest

Shares
Share This