Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i NEED THE SYNTAX INVOLED TO CARRY OUT THESE LAB. pLEASE ADD THE SYNTAX TO CARY OUT THIS LAB!!! - Edit the create_admin_users_and_roles.sql script a.

i NEED THE SYNTAX INVOLED TO CARRY OUT THESE LAB.

pLEASE ADD THE SYNTAX TO CARY OUT THIS LAB!!!

- Edit the create_admin_users_and_roles.sql script

a. remove "connect / as sysdba"

b. change the system password to your current system password.

- Edit the vpd_where_clause_orders.sql script to change the system password to your current system password.

- Edit the vpd_where_clause_customers.sql script to change the system password to your current system password.

- Edit the vpd_cleanup.sql script to change the conn / as sysdba; command to conn sys/ as sysdba; where is your current sys user password.

Once you have edited the script files listed in the steps above, run through the tutorial in the sequence given. Start Step 1 under Setup by logging in as the sys as sysdba user not /nolog. If you encounter errors with a particular script stop and troubleshoot before running the next script.

Note: Replace c:\wkdir\ listed in the tutorial with the path of the directory you are working from in the VM, /home/oracle/Desktop/vpd_lab_scripts/.

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

Step: 3

blur-text-image

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

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

0130913677, 978-0130913678

Students also viewed these Databases questions

Question

what are the provisions in the absence of Partnership Deed?

Answered: 1 week ago

Question

LO2.6 Explain how the market system deals with risk.

Answered: 1 week ago