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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!