Oracle database Unif… on Exploring Oracle 12c Unified… Rajesh on Oracle Database java component… Oracle Database Immu… on Oracle Database 19c Blockchain… Jeffrey on In-Memory Database Management… Upgrading TimeZone error ORA-56920: a prepare or upgrade window or an on-demand or datapump-job loading.ora-28031 maximum of 148 enabled roles exceeded.Performing Import Data Pump with EXCLUDE=STATISTICS.Oracle Database Product Life Cycle Support 19c,18c, 12cR2 Long Term & Innovation Releases !.Oracle data patch error Archived patch directory is empty.Oracle PDB and when is DAPTATCH required to be executed.How to View/List All ORA-XXXX Errors in your Oracle Database Systemįollow Geodata Master on Top Posts & Pages.Installing Workspace Manager in Oracle 19c.Oracle data patch error Archived patch directory is empty.SQL> grant select on sys.user$ to database_account So, to let the current version of TOAD works for 12c execute the following sql query: The reason in 12c they stripped those tables from “ SELECT ANY DICTIONARY” is to protect the passwords in case this privilege is granted to non-DBA account, so the hashed passwords are not exposed (ONLY SYS account can query those tables). The current TOAD version checks the old ( SELECT ANY DICTIONARY) which already has this table SYS.USER$ part of its permission when it can’t access this table, it throws the error message: ORA-01031 They have stripped this system privilege from accessing the following tables: USER$, ENC$,DEFAULT_PWD$, LINK$, USER_HISTORY$, CDB_LOCAL_ADMINAUTH$, XS$VERIFIERS The reason we are facing this problem, is the newly security implementation by Oracle in 12c for the system privilege SELECT ANY DICTIONARY. An issue faced is that when we try to connect from TOAD (version: 11.6 ) to a newly upgraded Oracle database 12c we faced the error:

Toad for oracle 12.1