In oracle PL/SQL I’ve written the following coding from 1 to 9. Now I need help

Question

In oracle PL/SQL I’ve written the following coding from 1 to 9.

Now I need help to fix part 10. Why can’t I connect with user1? How can I fix?

Thanks.

Create role account_managers;

            role ACCOUNT_MANAGERS created.

Grant update on OE.Customers to account_managers;

            Grant succeeded.

Create Role customer_service;

               role CUSTOMER_SERVICE created.

Grant select, update on OE.Customers to customer_service;

           Grant succeeded.

Create Role sales_reps

role SALES_REPS created

Grant select, insert, update on OE.Customers to sales_reps;

           Grant succeeded.

Create user user1 identified by Userpass123;

user USER1 created.

Grant account_managers to user1;

Grant succeeded.

Grant connect to user1;

Grant succeeded.

10.New connection to user1 giving this error

What did I do wrong and how can I fix it to be able to connect to user1?

Status:Failure_Test failed:ORA-01017:invalide username/password;logon denied.

Need help writing those queries too. Thanks.

Write a query that will display users and their privileges: use SYS_PRIVS

         Include SQL scripts, number of rows and screenshot of the results

Write SQL statement that lists all roles AND users (without repetition) who have access to the OE.CUSTOMERS table.

How can you check that whether ACCOUNT_MANAGERS have permission to update only one column in CUSTOMERS table?

Create an Oracle profile OE_PROFILE to limit database resources using the following criteria

-     Logon time—2 hours

-     Idle time—3 minutes

-     CPU time required per call—1 second

-     1 block per query

Assign profile OE_PROFILE to user1.

Explanation / Answer

to the following line of code

*Queries part

Part 1:we’ll use the DBA_TAB_PRIVS view to determine which users have direct grant access to a table

DBA_ROLE_PRIVS describes the roles granted to all users and the roles in the database.

#Create Profile

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.