From the course: Oracle Database 12c: Security
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating common users - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Creating common users
- [Instructor] Following our demo of creating local users, let's see how we can create our first common database user. Let us connect to our instance root container. We'll accomplish that by typing sqlplus, sys/oracle as sysdba. We can verify that we are indeed connected to our root container by typing show con_name. And let's create our first common user. So I'll type create user c sharp sharp, and let's call our user dba_user identified by and a password of password. Note the c sharp sharp in the username. This is the special prefix that is required for all common users that we create. We can verify that this user has indeed been created by querying the cdb underscore user's view. You can find a query included in your exercise file. So let's copy this query, and paste it in our SQL*Plus session. And as you can see, the C sharp sharp user was created. We see it multiple times, one for each of our pluggable databases, and we see that it is a common user. Remember that the cdb…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Users, schemas, and the SYSDBA5m
-
(Locked)
Create new database users6m 34s
-
(Locked)
Grant and evoke system privileges8m 4s
-
(Locked)
Grant database-wide system privileges6m 2s
-
(Locked)
Tablespace quotas5m 37s
-
(Locked)
Object permissions7m 39s
-
(Locked)
Password management policies7m 50s
-
(Locked)
The WITH GRANT and WITH ADMIN options3m 14s
-
(Locked)
Enforce password complexity6m 13s
-
(Locked)
Viewing users, permissions, and polices7m 32s
-
(Locked)
Deleting a database user4m 48s
-
(Locked)
Local vs. common user concepts2m 49s
-
(Locked)
Creating local users6m 45s
-
(Locked)
Creating common users7m 1s
-
(Locked)
Separating object owners and access5m 34s
-
-
-
-
-