604 SQLcl : Format Query Results with the SET SQLFORMAT Command. |
604 SQLcl : Format Query Results with the SET SQLFORMAT Command. |
605 |
605 |
606 Unlock expired password |
606 Unlock expired password |
607 ======================= |
607 ======================= |
608 |
608 |
|
609 Login as sysdba:: |
|
610 |
|
611 sqlplus / as sysdba |
|
612 |
|
613 Check expiration date for user:: |
|
614 |
|
615 select EXPIRY_DATE from DBA_USERS where USERNAME = 'me'; |
|
616 |
609 Connect as sysdba to the database and reset password and unlock user:: |
617 Connect as sysdba to the database and reset password and unlock user:: |
610 |
618 |
611 alter user <USER> identified by <PASSWORD>; |
619 alter user <USER> identified by <PASSWORD>; |
612 alter user <USER> account unlock; |
620 alter user <USER> account unlock; |
613 |
621 |
614 alter user <LUSER> identified by <PASSWORD> account unlock; |
622 or with single request:: |
|
623 |
|
624 alter user <USER> identified by <PASSWORD> account unlock; |
615 |
625 |
616 To make password lasts infinitely check which profile is used assigned:: |
626 To make password lasts infinitely check which profile is used assigned:: |
617 |
627 |
618 select USERNAME, PROFILE from DBA_USERS; |
628 select USERNAME, PROFILE from DBA_USERS; |
619 |
629 |
620 and check settings for this prifile:: |
630 and check settings for this profile:: |
621 |
631 |
622 select * from DBA_PROFILES where PROFILE = 'SA'; |
632 select * from DBA_PROFILES where PROFILE = 'SA'; |
623 |
633 |
624 and reset limits for password lifetime:: |
634 and reset limits for password lifetime:: |
625 |
635 |
629 |
639 |
630 create profile MY; |
640 create profile MY; |
631 alter profile MY PASSWORD_LIFE_TIME UNLIMITED; |
641 alter profile MY PASSWORD_LIFE_TIME UNLIMITED; |
632 alter user <USER> profile MY; |
642 alter user <USER> profile MY; |
633 |
643 |
|
644 To completely disable all password checks:: |
|
645 |
|
646 alter profile DEFAULT limit COMPOSITE_LIMIT UNLIMITED |
|
647 PASSWORD_LIFE_TIME UNLIMITED |
|
648 PASSWORD_REUSE_TIME UNLIMITED |
|
649 PASSWORD_REUSE_MAX UNLIMITED |
|
650 PASSWORD_VERIFY_FUNCTION NULL |
|
651 PASSWORD_LOCK_TIME UNLIMITED |
|
652 PASSWORD_GRACE_TIME UNLIMITED |
|
653 FAILED_LOGIN_ATTEMPTS UNLIMITED; |
|
654 |
634 Oracle naming conventions |
655 Oracle naming conventions |
635 ========================= |
656 ========================= |
636 |
657 |
637 http://www.gplivna.eu/papers/naming_conventions.htm |
658 http://www.gplivna.eu/papers/naming_conventions.htm |
638 https://oracle-base.com/articles/misc/naming-conventions |
659 https://oracle-base.com/articles/misc/naming-conventions |