To block end-user from access the database outside their application in SQL*Plus, you can use the PRODUCT_USER_PROFILE feature. It can be configured to disallow update operations. This is accomplished with the PRODUCT_USER_PROFILE table. Issuing the following row into this table will disable any ad-hoc updates with SQL*Plus: INSERT INTO PRODUCT_USER_PROFILE […]