Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need the steps involved to caayout this lab . The vpd scripts and the archive file, vpd.zip, are located in the vpd_lab_scripts directory

I just need the steps involved to caayout this lab.

The vpd scripts and the archive file, vpd.zip, are located in the vpd_lab_scripts directory on the oracle user's Desktop. . Note: Before starting the lab, in SQL*Plus (as Sys as sysdba), disable the password verification function enabled in Lab 2 by running the command: SQL> alter profile default limit password_verify_function NULL; 4. The scripts use the "OE" and "HR" sample schema users. The accounts should already be OPEN and their passwords are "oe" and "hr" respectively. Note: oe and hr are lowercase in the scripts. Passwords are case sensitive in 11g, but not in 10g. 5. Edit the create_admin_users_and_roles.sql script a. remove "connect / as sysdba" b. change the system password to your current system password. 6. Edit the vpd_where_clause_orders.sql script to change the system password to your current system password. 7. Edit the vpd_where_clause_customers.sql script to change the system password to your current system password. 8. 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_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

Postgresql 16 Administration Cookbook Solve Real World Database Administration Challenges With 180+ Practical Recipes And Best Practices

Authors: Gianni Ciolli ,Boriss Mejias ,Jimmy Angelakos ,Vibhor Kumar ,Simon Riggs

1st Edition

1835460585, 978-1835460580

More Books

Students also viewed these Databases questions

Question

1. Organize and support your main points

Answered: 1 week ago

Question

3. Move smoothly from point to point

Answered: 1 week ago

Question

5. Develop a strong introduction, a crucial part of all speeches

Answered: 1 week ago