web analytics

Oracle: how to clone profiles

Here is the simple script for cloning the Oracle profiles.

SET serveroutput ON DECLARE  CURSOR c_profiles IS   SELECT PROFILE, RESOURCE_NAME, LIMIT   FROM dba_profiles   ORDER BY PROFILE, resource_name;   s_PROFILE                     dba_profiles.PROFILE%TYPE ;   s_prev_PROFILE        dba_profiles.PROFILE%TYPE ;   s_RESOURCE_NAME     […]