Implementing Restrictions when Using Wildcards - Exercise

In earlier exercises you created the COIN database and several users. In this exercise you will use the PRODUCT_PROFILE table to place restrictions on two of those users so they cannot run certain commands when they connect with SQL*Plus.

Add the necessary rows to the PRODUCT_PROFILE table so that the users BID1 and BID2 are prevented from performing INSERT, UPDATE, and DELETE operations while using SQL*Plus.

You can use a wildcard in the userid column so that one set of statements covers both BID1 and BID2. Make the wildcard specific enough that it will not affect other users. Write a separate INSERT statement for each restricted command (INSERT, UPDATE, and DELETE).