From the course: Oracle Database 12c: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create users and assign permissions

Create users and assign permissions - Oracle Database Tutorial

From the course: Oracle Database 12c: Administration

Start my 1-month free trial

Create users and assign permissions

“

- [Instructor] Oracle comes built-in with a super user called Sys. Connecting to Sys from SQL Plus requires either adding as sysdba to the postfix, such as sqlplus sys/ the password, which is oracle in my case, and as sysdba. This will open a connection to the Oracle instance as the most powerful sys or sysdba user. Alternatively, we can just type sqlplus, quotation marks, as sysdba, and be connected to the instance with the sys, sysdba user. We don't need to supply a password specifically for the sys user, only because we are physically logged on to the same server where the Oracle instance is running. And, we are running SQL Plus from the Oracle Linux user, which is the user that started the Oracle instance. That is the only reason why we can skip the password for such a powerful user when logging on to the database. A connection with sys from any other machine in our network to our database, would have required us to supply the password. Creating additional users in Oracle is also…

Contents