I just need the steps involved to caayout this lab . The vpd scripts and the arc
ID: 3704980 • Letter: I
Question
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/”.
Explanation / Answer
Steps required to carry out the lab:
Step 1: Run the command 'alter profile default limit password_verify_function NULL'.
Step 2: Open the accounts of schema users OE and HR in the SQL Plus using their passwords oe and hr respectively.
Step 3: Now, edit the create_admin_users_and_roles.sql script and remove 'connect / as sysdba'.
Step 4: Change the system password to your current system password in the above sql file. Save the file and close it.
Step 5: Now, edit vpd_where_clause_orders.sql script file and change the system password to your current system password in the file. Then save the file and close it.
Step 6: Now, edit vpd_where_clause_customers.sql script file and change the system password to your current system password. Then save it and close it.
Step 7: Now, edit vpd_cleanup.sql script file and change the command 'conn / as sysdba;' to 'conn sys/ as sysdba;'.
Step 8: Now, login as the 'sys as sysdba' in SQL Plus and start running your scripts.
Thank you.