SQL Developer Create User

Аватар автора
IT Trends
In this video, we’ll look at how to create a new user on an Oracle database in SQL Developer. In an Oracle database, there are a couple of user accounts already created. However, these are system accounts, which have a lot of privileges. This can be dangerous as you (or other users) could do something bad to the database, either accidentally or on purpose. So, we should create our own users on the Oracle database. To do this, we can log in as one of the system accounts. I use SQL Developer in this video, but you can do the same thing in SQL*Plus or any other tool. You can watch the video to find out exactly how this is done, but in short, this is the process: - Log in as a system user - Create a new user with a password - Give them appropriate privileges - Create a new connection with the new user - Log in as the new user You should now be up and running with the new user! So that’s how you can create a new user in Oracle with SQL Developer. Let me know in the comments if you have any questions. For my complete Introduction to Oracle SQL course, visit this page:

0/0


0/0

0/0

0/0