Question
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/
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started