Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create a user in Oracle SQL developer

Tags:

oracle

I am newbie to oracle sql developer 3.1.07.42, and have just installed it on my machine. I want to make a new connection, but it requires a user and a password which I do not know. I have been googling about it since many days, and have learned that there are some commands to create user, but I do not know where should I run those commands, because I cannot run queries/commands until the connection is created. Would anyone let me know what should I do?

like image 286
Ruba Mushtaq Avatar asked Dec 09 '12 20:12

Ruba Mushtaq


1 Answers

Steps for creating new user :

1)Open Sql Developer, make new connection.

2)Login with System username and password(made during installation).

3)Once you connect, expand the System user (under Connections, in the left pane) and scroll down to Other users. Then right click users and add new user.

4)Give its username and password & select appropriate system privilege.

5)You are done now, check by making new connection.

like image 180
MKMohanty Avatar answered Sep 30 '22 16:09

MKMohanty