Question: In this exercise, you will create some users to be used for the remaining exercises in this chapter. It is assumed that there is a

In this exercise, you will create some users to be used for the remaining exercises in this chapter. It is assumed that there is a permanent tablespace called EXAMPLE and a temporary tablespace called TEMP. If these dont exist, either create them or use any other suitable tablespaces. Here are the steps to follow:

1. Connect to your database with SQL*Plus as a highly privileged user, such as SYSTEM or SYS.

2. Create three users:

create user alois identified by alois default tablespace example password expire;

create user afra identified by oracle default tablespace example quota unlimited on example;

create user anja identified by oracle;

***Book** OCA Oracle database 12c installation and administration

*** I need to see your sql plus screen shot

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!