Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE HELP FIX ERROR CODE IN PHOTO BELOW: You were just hired as a new junior Oracle database administrator (DBA) to assist a team of

PLEASE HELP FIX ERROR CODE IN PHOTO BELOW:

You were just hired as a new junior Oracle database administrator (DBA) to assist a team of five senior database administrators. In your first week, you were handed the task of writing a script for creating database users(using SQL Developer or SQL Plus). The script will perform the following tasks and conform to the following specifications:

1. Create the following two (2) users with their respective passwords. Please use the exact spelling. 

User NamePassword
DBSECTec5363%1
VPD_CLERK1Jessie#22

The following parameters apply to the above two (2) users.

2. The default table space is USERS. 

3. The temporary table space is TEMP. 

4. The user has to change his/her password the first time when he/she log in the database. 

5. The user account will be assigned to the DEFAULT profile. 

6. The USERS table space has a 30MB quota. 

7. At the end of the creation, list the user information that shows a successful creation of the above user account.

 

Screenshot (98).png 

SQL Plus SQL*Plus: Release 21.0.0.0.0 Version 21.3.0.0.0 Production on Tue Jan 25 16:13:01 2022 Copyright (c) 1982, 2021, Oracle. All rights reserved. Enter user-name: sqlplus/ as sysdba Enter password: Connected to: Oracle Database 21c Express Edition Release 21.0.0.0.0 Production Version 21.3.0.0.0 SQL> SHOW USER USER is "SYS" SQL> CREATE USER DBSEC IDENTIFIED BY "Tech5363% 1" 2 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP 3 4 PASSWORD EXPIRE 5 PROFILE DEFAULT 6 QUOTA 30M on USERS; CREATE USER DBSEC IDENTIFIED BY "Tech5363%1" ERROR at line 1: ORA-65096: invalid common user or role name SQL> H Type here to search 0 I C 56F 4:15 PM 1/25/2022

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing

Authors: Dhruv Grewal, Michael Levy

5th edition

1259446298, 978-1259446290

More Books

Students also viewed these Databases questions

Question

Solve the following the equation. 3y-4=3(y+6)-2(y+3)

Answered: 1 week ago

Question

Solve the following the equation. 8-0.5(x+3)=0.25(x-1)

Answered: 1 week ago