How to Create a User in Oracle SQL Developer

Using Oracle SQL Developer to create a user is fairly easy. In short, you'll need to log in as an admin user and run some SQL commands.

In Oracle SQL Developer CREATE USER is the first command to run. You'll then need to run several GRANT commands to give this new user the privileges to be able to log in and work with data.

I cover the steps to take in this video, as well as the minimum privileges you'll need. You can run these commands in any SQL IDE, but I've demonstrated them in SQL Developer as it's a common IDE that Oracle developers use.

[parthdandawate]

Your Solution worked for my problem! Thank you, Sir!

[ashishtayade]

Thank you sir very nice gide & very nice best explain how to create a user in oracle SQL developer teaching video.👍

[Darkknight]

now how do i connect to this intro_user from a different computer(using different internet connection)?

[shan]

hi this didn't work for me. I tried creating a new user using the virtual box connection and its saying I have insufficient privileges. I had to create this virtual connection by following your last video for installing sql on a Mac. Im not able to find the virtual box IP address so I don't know how to connect to my system account instead of the virtual one

[avudurthisrinivas]

hiii i am trying to create a new user but i am getting below error
CREATE USER intro_user IDENTIFIED BY anusha

Error report -
ORA-65096: invalid common user or role name
65096. - "invalid common user or role name"
*Cause: An attempt was made to create a common user or role with a name
that was not valid for common users or roles. In addition to the
usual rules for user and role names, common user and role names
must consist only of ASCII characters, and must contain the prefix
specified in common_user_prefix parameter.
*Action: Specify a valid common user or role name.
will you please help me to reslove this issue ??

[tomas]

i created new user with sys user and granted all those permissions but when i try to reconnect with that new user it gives me error invalid username/password even tho its all correct.

[MohamedMontaser]

do you do this at the container db or the pluggable db?

[danahbawazeer]

Hello there
Thank you for this useful tutorial, and I’m a student and a beginner at this, and you made it very clear!

I have a question tho, after creating a user, can my friend use it and have access to the tables i create? Thanks in advance!

[Abioladavid]

Hi,

Thanks for the videos. Hoe do I write a SQL Plus Query to grant Read/Only privileges to user to access few tables??


Thanks

[remloyola]

Why does mine says insufficient priveleges