Log into new User in SQL

Rumman Ansari   Software Engineer   2023-03-25   6019 Share
☰ Table of Contents

Table of Content:


In this section we are going to teach you how to connect to your newly created user. In my case the user name is atnylaUser and the password rumman_ansari. If you don't know how to create a new user see previous tutorials.

Below is our query to connect with our newly created user.

SQL Query

  SQL> connect atnylaUser/rumman_ansari;
  Connected.
  SQL>

Now I am connected to my user. If you want to cross check whether you are connected or not run the below query.

SQL Query

  SQL> SHOW user;
  USER is "ATNYLAUSER"
  SQL>

So here it is, we are connected with our user: atnylaUser

Hey, Now we are ready to create your own database inside our own user. So I think you areaready to create a new database. To create a new database check the next section.