Question: Having a hard time with these questions. Please provide code of how to complete these questions Use SQL Plus for questions 1 and 5 Use
Having a hard time with these questions. Please provide code of how to complete these questions
Use SQL Plus for questions 1 and 5
Use SQL Developer for questions 2, 3,4,6,7.
1. Use SQLPlus to connect as user1. Explain what happened and way to fix it.
2. Give user1 permission to see information in OE.CUSTOMERS table
3. Test the permission you granted
4. As user1 update the last name of the customer with customer ID 188. Explain results.
5. Use SQLPlus. Login as user1, and describe how you changed the password.
6. Check permissions you granted by using data dictionary view
7. Check permissions you granted by using user1 account to update OE.CUSTOMERS table.
Any help would be greatly appreciated.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
