equal
deleted
inserted
replaced
527 select * from tbl where ...; |
527 select * from tbl where ...; |
528 spool off; |
528 spool off; |
529 |
529 |
530 https://dba.stackexchange.com/questions/173540/generate-insert-statements-for-each-entry-in-a-table |
530 https://dba.stackexchange.com/questions/173540/generate-insert-statements-for-each-entry-in-a-table |
531 Generate ``insert`` statements for each entry in a table. |
531 Generate ``insert`` statements for each entry in a table. |
|
532 |
|
533 Unlock expired password |
|
534 ======================= |
|
535 |
|
536 Connect as sysdba to the database and reset password and unlock user:: |
|
537 |
|
538 alter user <USER> identified by <PASSWORD>; |
|
539 alter user <USER> account unlock; |
|
540 |
|
541 alter user <LUSER> identified by <PASSWORD> account unlock; |
|
542 |
|
543 To make password lasts infinitely check which profile is used assigned:: |
|
544 |
|
545 select USERNAME, PROFILE from DBA_USERS; |
|
546 |
|
547 and check settings for this prifile:: |
|
548 |
|
549 select * from DBA_PROFILES where PROFILE = 'SA'; |
|
550 |
|
551 and reset limits for password lifetime:: |
|
552 |
|
553 alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED; |
|
554 |
|
555 You may create separate profile with its own settings:: |
|
556 |
|
557 create profile MY; |
|
558 alter profile MY PASSWORD_LIFE_TIME UNLIMITED; |
|
559 alter user <USER> profile MY; |
|
560 |