Shredding the Database Privilege

Now that you have completed the upgrade, you can shred out the database privilege given to the database user. This is an optional task.

Procedure

  • Log into the Oracle database as sysdba and execute: 
    SQL> REVOKE CREATE DATABASE LINK FROM <fom-db-user>;