Log into new User in SQL
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.