Thursday, 9 June 2016

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.

No comments:

Post a Comment