Oracle Database Discussions

Is there a way to generate the code behind a profile? I tried "get_ddl" but it did not work as I guess Oracle does not treat profile as an Object. I guess i can use the expdp and dump the code to a file but is there any other way?


I'd like the output to be something like this ..

create profile PROD_USER limit
sessions_per_user 12
cpu_per_session unlimited
cpu_per_call unlimited
connect_time unlimited
idle_time 2500
logical_reads_per_session unlimited
composite_limit unlimited
private_sga unlimited
failed_login_attempts 3
password_life_time 180
password_reuse_time unlimited
password_reuse_max unlimited
password_grace_time 3
password_verify_function VERIFY_FUNCTION;

Thanks in advance