Amazon books

Tuesday, February 4, 2014

Check and Disable SQL Profile in Oracle

1-Check enabled profiles

select NAME,CREATED,STATUS from dba_sql_profiles;

2-Disable the required profile

EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('coe_7by859jup2hvt_1730647264','STATUS','DISABLED');

Best Regards,
Paulo Portugal

No comments:

Post a Comment