Toad World® Forums

Toad 13 - In Schema Browser, "Profiles" is missing very important information for Oracle 12.2


#1

In Oracle 12.2 DBA_PROFILES has a RESOURCE_NAME of INACTIVE_ACCOUNT_TIME. To confirm this, issue the following SQL. “select distinct resource_name from dba_profiles order by resource_name;”

When scripting out a Profile, or viewing a Profile in the Schema Browser INACTIVE_ACCOUNT_TIME is missing. Although INACTIVE_ACCOUNT_TIME is set to UNLIMITED with the DEFAULT profile, it is set to 35 days with the ORA_STIG_PROFILE. The SCHEMA BROWSER in Toad 13 is missing this very important information.

Helen


#2

Thanks, I’ve logged this and we’ll get it added for Toad 13.1.