From the course: Oracle Database 12c: Security

Unlock the full course today

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

Creating local users

Creating local users - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Creating local users

“

- [Instructor] Let's see a quick demo where we'll create both a Common User as well as a Local User in our Oracle instance. Before we can start, let's prepare our demo by creating two plugagble databases or PDBs which we'll use later on. We will start by connecting to our Oracle instance root container as the SYSDBA user. So I'll type sqlplus sys/oracle as sysdba. I can verify that I'm connected to the root container by typing show con_name. As you can see, CDB$ROOT signifies that I'm indeed connected to the root container. And now let's create a couple of pluggable databases. We'll call them demo pdb1 and demo pdb2. If you are unfamiliar with pluggable databases in Oracle 12c or need a quick refresher, then please be sure to check my Oracle 12c New Features course which is available in the library and covers these topics plus many, many more. So let's create our pluggable databases. You can find the commands for creating demo_pdb1 and demo_pdb2 included in your exercise file. So…

Contents