20 June 2011

ORACLE - Disable password expiry

Unlike older releases, Oracle11g sets password expiry by DEFAULT. Get rid of these with:

SQL> alter profile default limit
failed_login_attempts unlimited
password_life_time unlimited;
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Wordpress - Local installation in Vmware

If you're interested in exploring website design with WordPress, this guide will help you set up a WordPress instance on your local mach...

  • PostgreSQL - Step by step guide installation from source
    [Tested On] CentOS Linux release 7.4.1708 (Core) # wget https://ftp.postgresql.org/pub/source/v9.6.6/postgresql-9.6.6.tar.gz # tar xvzf post...
  • LINUX - Test ping ipv6 address
    [Tested On] Red Hat Enterprise Linux Server release 7.4 (Maipo) --- Obtain your ipv6 address and network device information # ifconfig --- T...
  • ORACLE - Show errors
    To identify compilation errors in triggers and procedures SQL>show errors trigger UT_AUTONUMUPD; LINE/COL ERROR -------- ----------------...