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"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 ;-).
IDENTIFIED BY "THE_PASSWORD" DEFAULT TABLESPACE "THE_TABLESPACE"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED
ON "SOME_OTHER_TABLESPACE"
ACCOUNT UNLOCK;
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