Oracle News
Posted by Alex Lima on October 22, 2009
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON
NAME TYPE VALUE
———————————— ———– ——————————
sec_case_sensitive_logon boolean TRUE
SQL>
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
System altered.
Posted in Security | Tagged: 11g, case, enable, logon, sensitive | Leave a Comment »
Posted by Alex Lima on October 22, 2009
Now Oracle has a quick way to find users with detault password.
SQL> SELECT * FROM dba_users_with_defpwd;
And here is the output:
USERNAME
——————————
DIP
MDSYS
WK_TEST
CTXSYS
OLAPSYS
OUTLN
EXFSYS
SCOTT
MDDATA
ORDPLUGINS
ORDSYS
XDB
LBACSYS
SI_INFORMTN_SCHEMA
WMSYS
Posted in General DBA, Security | Tagged: account, DEFAULT, determine, find, oracle, password, schema | Leave a Comment »
Alex Lima
Amin Jaffer