{"id":9306,"date":"2026-06-04T03:13:12","date_gmt":"2026-06-04T06:13:12","guid":{"rendered":"https:\/\/executestep.com\/?p=9306"},"modified":"2026-06-04T03:13:13","modified_gmt":"2026-06-04T06:13:13","slug":"account-status-oracle-dba-users","status":"publish","type":"post","link":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/","title":{"rendered":"ACCOUNT_STATUS no Oracle: o que significa cada valor"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sua aplica\u00e7\u00e3o parou de conectar e o erro \u00e9 direto:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ORA-28000: the account is locked<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">ORA-28000: the account is locked<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">ou:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ORA-28001: the password has expired<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">ORA-28001: the password has expired<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de sair rodando <code>ALTER USER<\/code>, o primeiro passo \u00e9 descobrir o estado real da conta. Quem responde isso \u00e9 a coluna <code>ACCOUNT_STATUS<\/code> da view <code>DBA_USERS<\/code>. Ela diz se a conta est\u00e1 aberta, bloqueada, com senha expirada, ou uma combina\u00e7\u00e3o disso. Cada estado pede uma a\u00e7\u00e3o diferente, e desbloquear no escuro s\u00f3 adia o problema.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Como checar o status<\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT username, account_status\nFROM   dba_users\nWHERE  username = 'APP_USER';<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> username, account_status<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\">   dba_users<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\">  username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">APP_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>USERNAME    ACCOUNT_STATUS\n----------- --------------------------------\nAPP_USER    LOCKED(TIMED)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">USERNAME    ACCOUNT_STATUS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">----------- --------------------------------<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">APP_USER    LOCKED(TIMED)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1 Use sempre <code>DBA_USERS<\/code> para diagn\u00f3stico. A <code>ALL_USERS<\/code> traz menos colunas e nem sempre te d\u00e1 o status completo.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">A fonte da verdade: user_astatus_map<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e3o decore a lista de valores. O pr\u00f3prio banco tem ela. A tabela <code>user_astatus_map<\/code> mostra todos os estados poss\u00edveis na sua vers\u00e3o:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT * FROM user_astatus_map;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">*<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> user_astatus_map;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>   STATUS# STATUS\n---------- --------------------------------\n         0 OPEN\n         1 EXPIRED\n         2 EXPIRED(GRACE)\n         4 LOCKED(TIMED)\n         8 LOCKED\n         5 EXPIRED &amp; LOCKED(TIMED)\n         6 EXPIRED(GRACE) &amp; LOCKED(TIMED)\n         9 EXPIRED &amp; LOCKED\n        10 EXPIRED(GRACE) &amp; LOCKED\n        32 OPEN &amp; IN ROLLOVER\n        33 EXPIRED &amp; IN ROLLOVER\n        36 LOCKED(TIMED) &amp; IN ROLLOVER\n        37 EXPIRED &amp; LOCKED(TIMED) &amp; IN ROLLOVER\n        40 LOCKED &amp; IN ROLLOVER\n        41 EXPIRED &amp; LOCKED &amp; IN ROLLOVER<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">   STATUS# STATUS<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">---------- --------------------------------<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         0 OPEN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         1 EXPIRED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         2 EXPIRED(GRACE)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         4 LOCKED(TIMED)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         8 LOCKED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         5 EXPIRED &amp; LOCKED(TIMED)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         6 EXPIRED(GRACE) &amp; LOCKED(TIMED)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">         9 EXPIRED &amp; LOCKED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        10 EXPIRED(GRACE) &amp; LOCKED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        32 OPEN &amp; IN ROLLOVER<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        33 EXPIRED &amp; IN ROLLOVER<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        36 LOCKED(TIMED) &amp; IN ROLLOVER<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        37 EXPIRED &amp; LOCKED(TIMED) &amp; IN ROLLOVER<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        40 LOCKED &amp; IN ROLLOVER<\/span><\/span>\n<span class=\"line\"><span style=\"color: #d8dee9ff\">        41 EXPIRED &amp; LOCKED &amp; IN ROLLOVER<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1 O <code>STATUS#<\/code> \u00e9 um bitmask. Cada estado \u00e9 a soma de flags base. Se a sua vers\u00e3o n\u00e3o suportar gradual password rollover, voc\u00ea ver\u00e1 apenas os 9 primeiros valores (sem os <code>&amp; IN ROLLOVER<\/code>).<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">O que cada estado significa<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">S\u00e3o 6 flags base. Todos os 15 valores do <code>user_astatus_map<\/code> s\u00e3o combina\u00e7\u00f5es deles somados.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Flag base<\/th><th>STATUS#<\/th><th>O que aconteceu<\/th><th>A\u00e7\u00e3o<\/th><\/tr><\/thead><tbody><tr><td><code>OPEN<\/code><\/td><td>0<\/td><td>Conta ativa, senha v\u00e1lida.<\/td><td>Nenhuma.<\/td><\/tr><tr><td><code>EXPIRED<\/code><\/td><td>1<\/td><td>A senha expirou (pol\u00edtica ou expira\u00e7\u00e3o manual).<\/td><td>Redefinir a senha.<\/td><\/tr><tr><td><code>EXPIRED(GRACE)<\/code><\/td><td>2<\/td><td>A senha entrou no per\u00edodo de toler\u00e2ncia (<code>PASSWORD_GRACE_TIME<\/code>). Ainda conecta, mas avisa.<\/td><td>Trocar a senha antes de virar <code>EXPIRED<\/code>.<\/td><\/tr><tr><td><code>LOCKED(TIMED)<\/code><\/td><td>4<\/td><td>Bloqueio autom\u00e1tico ap\u00f3s <code>FAILED_LOGIN_ATTEMPTS<\/code> tentativas erradas.<\/td><td>Desbloquear, ou esperar o <code>PASSWORD_LOCK_TIME<\/code> expirar.<\/td><\/tr><tr><td><code>LOCKED<\/code><\/td><td>8<\/td><td>Bloqueio manual feito pelo DBA (<code>ACCOUNT LOCK<\/code>).<\/td><td>Desbloquear manualmente. N\u00e3o se resolve sozinho.<\/td><\/tr><tr><td><code>IN ROLLOVER<\/code><\/td><td>32<\/td><td>Senha em rollover gradual: a antiga e a nova valem ao mesmo tempo.<\/td><td>Concluir a migra\u00e7\u00e3o e encerrar o per\u00edodo.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A leitura das combina\u00e7\u00f5es \u00e9 s\u00f3 a soma. Exemplos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>9 = 1 + 8<\/code> = <code>EXPIRED &amp; LOCKED<\/code><\/li>\n\n\n\n<li><code>5 = 1 + 4<\/code> = <code>EXPIRED &amp; LOCKED(TIMED)<\/code><\/li>\n\n\n\n<li><code>37 = 1 + 4 + 32<\/code> = <code>EXPIRED &amp; LOCKED(TIMED) &amp; IN ROLLOVER<\/code><\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f A distin\u00e7\u00e3o que mais confunde: <code>LOCKED<\/code> (8) \u00e9 a\u00e7\u00e3o humana, algu\u00e9m rodou <code>ACCOUNT LOCK<\/code>. <code>LOCKED(TIMED)<\/code> (4) \u00e9 o banco bloqueando ap\u00f3s N falhas de login. Se voc\u00ea v\u00ea <code>LOCKED(TIMED)<\/code> voltando toda hora, n\u00e3o \u00e9 manuten\u00e7\u00e3o: \u00e9 tentativa de login com senha errada (app com senha velha, job mal configurado, brute force). Ache a origem antes de s\u00f3 desbloquear.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">IN ROLLOVER: o estado novo que pega gente desprevenida<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se o status traz <code>&amp; IN ROLLOVER<\/code>, a conta est\u00e1 em <strong>gradual password rollover<\/strong>. Esse recurso chegou no Oracle 21c e foi backportado para o 19c a partir do 19.12. Ele permite trocar a senha de um usu\u00e1rio e manter a senha antiga v\u00e1lida por um per\u00edodo, para as aplica\u00e7\u00f5es migrarem sem downtime.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Durante esse per\u00edodo, a conta mostra, por exemplo:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>OPEN &amp; IN ROLLOVER<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">OPEN &amp; IN ROLLOVER<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">e tanto a senha antiga quanto a nova funcionam ao mesmo tempo.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ativar no profile (valor em dias, m\u00ednimo 1 hora = <code>1\/24<\/code>, m\u00e1ximo 60 dias ou o menor entre <code>PASSWORD_LIFE_TIME<\/code> e <code>PASSWORD_GRACE_TIME<\/code>):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER PROFILE app_profile LIMIT PASSWORD_ROLLOVER_TIME 1;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> app_profile <\/span><span style=\"color: #81A1C1\">LIMIT<\/span><span style=\"color: #D8DEE9FF\"> PASSWORD_ROLLOVER_TIME <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Encerrar o rollover antes do prazo (corta a senha antiga na hora):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER app_user EXPIRE PASSWORD ROLLOVER PERIOD;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user EXPIRE <\/span><span style=\"color: #81A1C1\">PASSWORD<\/span><span style=\"color: #D8DEE9FF\"> ROLLOVER <\/span><span style=\"color: #81A1C1\">PERIOD<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Desligar o recurso no profile:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER PROFILE app_profile LIMIT PASSWORD_ROLLOVER_TIME 0;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> app_profile <\/span><span style=\"color: #81A1C1\">LIMIT<\/span><span style=\"color: #D8DEE9FF\"> PASSWORD_ROLLOVER_TIME <\/span><span style=\"color: #B48EAD\">0<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Como resolver cada caso<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Da a\u00e7\u00e3o mais segura para a mais agressiva.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Conta bloqueada (<code>LOCKED<\/code> ou <code>LOCKED(TIMED)<\/code>):<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER app_user ACCOUNT UNLOCK;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user ACCOUNT <\/span><span style=\"color: #81A1C1\">UNLOCK<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f Se for <code>LOCKED(TIMED)<\/code>, desbloquear sem achar a origem das falhas s\u00f3 adia o problema: a conta trava de novo no pr\u00f3ximo ciclo de tentativas erradas. Cheque o listener log e a auditoria para ver qual host est\u00e1 tentando com senha velha.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Senha expirada (<code>EXPIRED<\/code> ou <code>EXPIRED(GRACE)<\/code>):<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f Trocar a senha de um usu\u00e1rio de aplica\u00e7\u00e3o derruba conex\u00f5es que ainda usam a senha antiga. No 19.12+ e 21c, prefira o gradual password rollover para fazer a troca sem downtime.<\/p>\n<\/blockquote>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER app_user IDENTIFIED BY nova_senha;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> nova_senha;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Bloqueada e expirada ao mesmo tempo (ex.: <code>EXPIRED &amp; LOCKED<\/code>):<\/strong><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER app_user ACCOUNT UNLOCK;\nALTER USER app_user IDENTIFIED BY nova_senha;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user ACCOUNT <\/span><span style=\"color: #81A1C1\">UNLOCK<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> nova_senha;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Reproduzindo cada estado em lab<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Quer provocar cada estado e ver o <code>account_status<\/code> mudar? Crie tr\u00eas profiles dedicados e um usu\u00e1rio de teste. Cada cen\u00e1rio s\u00f3 aponta o profile certo, sem <code>ALTER PROFILE<\/code> de ida e volta. Rode tudo dentro de uma PDB.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Setup<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- Profiles dedicados (cria uma vez)\nCREATE PROFILE lab_base LIMIT\n  FAILED_LOGIN_ATTEMPTS 3\n  PASSWORD_LOCK_TIME    1\/1440;   -- 1 min: garante LOCKED(TIMED) e auto-unlock rapido\n\nCREATE PROFILE lab_grace LIMIT\n  PASSWORD_LIFE_TIME  1\/1440      -- 1 min\n  PASSWORD_GRACE_TIME 1\/1440;     -- 1 min\n\nCREATE PROFILE lab_rollover LIMIT\n  PASSWORD_LIFE_TIME     UNLIMITED\n  PASSWORD_GRACE_TIME    UNLIMITED\n  PASSWORD_ROLLOVER_TIME 1\/24;    -- 1 hora (minimo permitido)\n\n-- Usuario de teste, comeca no profile base\nCREATE USER lab_user IDENTIFIED BY \"Senha#123\" PROFILE lab_base;\nGRANT CREATE SESSION TO lab_user;\n\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- OPEN<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- Profiles dedicados (cria uma vez)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base <\/span><span style=\"color: #81A1C1\">LIMIT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  FAILED_LOGIN_ATTEMPTS <\/span><span style=\"color: #B48EAD\">3<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_LOCK_TIME    <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">1440<\/span><span style=\"color: #D8DEE9FF\">;   <\/span><span style=\"color: #616E88\">-- 1 min: garante LOCKED(TIMED) e auto-unlock rapido<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_grace <\/span><span style=\"color: #81A1C1\">LIMIT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_LIFE_TIME  <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">1440<\/span><span style=\"color: #D8DEE9FF\">      <\/span><span style=\"color: #616E88\">-- 1 min<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_GRACE_TIME <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">1440<\/span><span style=\"color: #D8DEE9FF\">;     <\/span><span style=\"color: #616E88\">-- 1 min<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_rollover <\/span><span style=\"color: #81A1C1\">LIMIT<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_LIFE_TIME     <\/span><span style=\"color: #81A1C1\">UNLIMITED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_GRACE_TIME    <\/span><span style=\"color: #81A1C1\">UNLIMITED<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">  PASSWORD_ROLLOVER_TIME <\/span><span style=\"color: #B48EAD\">1<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #B48EAD\">24<\/span><span style=\"color: #D8DEE9FF\">;    <\/span><span style=\"color: #616E88\">-- 1 hora (minimo permitido)<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Usuario de teste, comeca no profile base<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">lab_user<\/span><span style=\"color: #D8DEE9FF\"> IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">GRANT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">SESSION<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">TO<\/span><span style=\"color: #D8DEE9FF\"> lab_user;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- OPEN<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f N\u00e3o d\u00e1 pra juntar tudo num profile s\u00f3. O <code>PASSWORD_ROLLOVER_TIME<\/code> precisa ser no m\u00ednimo 1 hora e no m\u00e1ximo o menor entre <code>PASSWORD_LIFE_TIME<\/code> e <code>PASSWORD_GRACE_TIME<\/code>. Como o cen\u00e1rio de grace usa 1 minuto, grace curto e rollover s\u00e3o mutuamente exclusivos no mesmo profile. Juntar os dois retorna <code>ORA-65211<\/code>.<\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f Se o <code>PASSWORD_LOCK_TIME<\/code> for <code>UNLIMITED<\/code>, o bloqueio por falhas aparece como <code>LOCKED<\/code> (sem TIMED), porque a conta nunca destrava sozinha. Por isso o <code>lab_base<\/code> fixa um valor finito.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">LOCKED (bloqueio manual)<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_base;\n\nALTER USER lab_user ACCOUNT LOCK;\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- LOCKED\n\nALTER USER lab_user ACCOUNT UNLOCK;\n-- volta para OPEN<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user ACCOUNT LOCK;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- LOCKED<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user ACCOUNT <\/span><span style=\"color: #81A1C1\">UNLOCK<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- volta para OPEN<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">LOCKED(TIMED) (bloqueio autom\u00e1tico)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Esse cen\u00e1rio depende do <code>FAILED_LOGIN_ATTEMPTS<\/code> e do <code>PASSWORD_LOCK_TIME<\/code>, ent\u00e3o garanta o <code>lab_base<\/code> antes:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_base;\n\n-- erre a senha 3x (FAILED_LOGIN_ATTEMPTS), cada uma retorna ORA-01017\nCONNECT lab_user\/senha_errada\n\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- LOCKED(TIMED)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- erre a senha 3x (FAILED_LOGIN_ATTEMPTS), cada uma retorna ORA-01017<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CONNECT<\/span><span style=\"color: #D8DEE9FF\"> lab_user<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #D8DEE9FF\">senha_errada<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- LOCKED(TIMED)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">O auto-unlock por tempo \u00e9 <strong>lazy<\/strong>: o Oracle s\u00f3 reavalia o lock no pr\u00f3ximo login, n\u00e3o por um timer em background. Por isso a <code>DBA_USERS<\/code> continua mostrando <code>LOCKED(TIMED)<\/code> mesmo depois do <code>PASSWORD_LOCK_TIME<\/code> passar, at\u00e9 algu\u00e9m tentar conectar.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- opcao 1: desbloqueio manual, imediato\nALTER USER lab_user ACCOUNT UNLOCK;\n\n-- opcao 2: passado o PASSWORD_LOCK_TIME (1 min neste lab), conecte com a senha correta.\n-- o login dispara a reavaliacao, conecta, e o status volta para OPEN\nCONNECT lab_user\/\"Senha#123\"<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- opcao 1: desbloqueio manual, imediato<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user ACCOUNT <\/span><span style=\"color: #81A1C1\">UNLOCK<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- opcao 2: passado o PASSWORD_LOCK_TIME (1 min neste lab), conecte com a senha correta.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- o login dispara a reavaliacao, conecta, e o status volta para OPEN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CONNECT<\/span><span style=\"color: #D8DEE9FF\"> lab_user<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote has-small-font-size is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f Consultar a <code>DBA_USERS<\/code> n\u00e3o destrava nada. S\u00f3 uma tentativa de login reavalia o <code>PASSWORD_LOCK_TIME<\/code>. Esperar e dar <code>SELECT<\/code> de novo vai continuar mostrando <code>LOCKED(TIMED)<\/code>.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\">EXPIRED (expira\u00e7\u00e3o manual)<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_base;\n\nALTER USER lab_user PASSWORD EXPIRE;\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- EXPIRED\n\nALTER USER lab_user IDENTIFIED BY \"Senha#123\";\n-- volta para OPEN<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PASSWORD<\/span><span style=\"color: #D8DEE9FF\"> EXPIRE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- EXPIRED<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- volta para OPEN<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">EXPIRED(GRACE) (toler\u00e2ncia por tempo)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Esse depende de tempo passar. Troque para o <code>lab_grace<\/code>, reinicie o rel\u00f3gio da senha, espere e conecte:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_grace;\nALTER USER lab_user IDENTIFIED BY \"Senha#123\";   -- reinicia o relogio da senha\n\n-- espere ~1 minuto e conecte (a conexao dispara a verificacao)\nCONNECT lab_user\/\"Senha#123\"\n-- Aviso ORA-28002: the password will expire within ... days\n\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- EXPIRED(GRACE)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_grace;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\">;   <\/span><span style=\"color: #616E88\">-- reinicia o relogio da senha<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- espere ~1 minuto e conecte (a conexao dispara a verificacao)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">CONNECT<\/span><span style=\"color: #D8DEE9FF\"> lab_user<\/span><span style=\"color: #81A1C1\">\/<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- Aviso ORA-28002: the password will expire within ... days<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- EXPIRED(GRACE)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Passado o <code>PASSWORD_GRACE_TIME<\/code>, o status vira <code>EXPIRED<\/code>. Para limpar, volte ao profile base e redefina a senha:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_base;\nALTER USER lab_user IDENTIFIED BY \"Senha#123\";<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">Senha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">OPEN &amp; IN ROLLOVER (rollover gradual)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Precisa de 19.12+ ou 21c. Troque para o <code>lab_rollover<\/code> e mude a senha:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_rollover;\n\nALTER USER lab_user IDENTIFIED BY \"NovaSenha#123\";\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- OPEN &amp; IN ROLLOVER<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_rollover;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #A3BE8C\">NovaSenha#123<\/span><span style=\"color: #ECEFF4\">&quot;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- OPEN &amp; IN ROLLOVER<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Durante o rollover, as duas senhas conectam. Encerre antes do prazo (s\u00f3 a nova continua v\u00e1lida):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user EXPIRE PASSWORD ROLLOVER PERIOD;\n-- volta para OPEN<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user EXPIRE <\/span><span style=\"color: #81A1C1\">PASSWORD<\/span><span style=\"color: #D8DEE9FF\"> ROLLOVER <\/span><span style=\"color: #81A1C1\">PERIOD<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- volta para OPEN<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Combina\u00e7\u00f5es<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00c9 s\u00f3 somar os gatilhos. Exemplo de <code>EXPIRED &amp; LOCKED<\/code> (no <code>lab_base<\/code>):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>ALTER USER lab_user PROFILE lab_base;\nALTER USER lab_user PASSWORD EXPIRE;\nALTER USER lab_user ACCOUNT LOCK;\nSELECT account_status FROM dba_users WHERE username = 'LAB_USER';\n-- EXPIRED &amp; LOCKED<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user <\/span><span style=\"color: #81A1C1\">PASSWORD<\/span><span style=\"color: #D8DEE9FF\"> EXPIRE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user ACCOUNT LOCK;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">LAB_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- EXPIRED &amp; LOCKED<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Limpeza<\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>DROP USER lab_user CASCADE;\nDROP PROFILE lab_base;\nDROP PROFILE lab_grace;\nDROP PROFILE lab_rollover;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> lab_user CASCADE;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_base;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_grace;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">DROP<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">PROFILE<\/span><span style=\"color: #D8DEE9FF\"> lab_rollover;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Checklist r\u00e1pido<\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>-- 1. Ver o status atual\nSELECT username, account_status FROM dba_users WHERE username = 'APP_USER';\n\n-- 2. Conferir os valores poss\u00edveis na sua vers\u00e3o\nSELECT * FROM user_astatus_map;\n\n-- 3. Desbloquear\nALTER USER app_user ACCOUNT UNLOCK;\n\n-- 4. Redefinir a senha (cuidado com downtime)\nALTER USER app_user IDENTIFIED BY nova_senha;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #616E88\">-- 1. Ver o status atual<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> username, account_status <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> dba_users <\/span><span style=\"color: #81A1C1\">WHERE<\/span><span style=\"color: #D8DEE9FF\"> username <\/span><span style=\"color: #81A1C1\">=<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #A3BE8C\">APP_USER<\/span><span style=\"color: #ECEFF4\">&#39;<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 2. Conferir os valores poss\u00edveis na sua vers\u00e3o<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">SELECT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">*<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">FROM<\/span><span style=\"color: #D8DEE9FF\"> user_astatus_map;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 3. Desbloquear<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user ACCOUNT <\/span><span style=\"color: #81A1C1\">UNLOCK<\/span><span style=\"color: #D8DEE9FF\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #616E88\">-- 4. Redefinir a senha (cuidado com downtime)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">ALTER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">USER<\/span><span style=\"color: #D8DEE9FF\"> app_user IDENTIFIED <\/span><span style=\"color: #81A1C1\">BY<\/span><span style=\"color: #D8DEE9FF\"> nova_senha;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Refer\u00eancias<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Database Reference: <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/refrn\/DBA_USERS.html\">DBA_USERS<\/a><\/li>\n\n\n\n<li>ORACLE-BASE: <a href=\"https:\/\/oracle-base.com\/articles\/21c\/gradual-database-password-rollover-time-21c\">Gradual Database Password Rollover Time (PASSWORD_ROLLOVER_TIME)<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Sua aplica\u00e7\u00e3o parou de conectar e o erro \u00e9 direto: ou: Antes de sair rodando ALTER USER, o primeiro passo \u00e9 descobrir o estado real da conta. Quem responde isso \u00e9 a coluna ACCOUNT_STATUS da view DBA_USERS. Ela diz se a conta est\u00e1 aberta, bloqueada, com senha expirada, ou uma combina\u00e7\u00e3o disso. Cada estado pede<\/p>\n","protected":false},"author":1,"featured_media":9312,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[174],"tags":[395,313],"class_list":["post-9306","post","type-post","status-publish","format-standard","has-post-thumbnail","category-oracle","tag-dba_users","tag-lab"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep<\/title>\n<meta name=\"description\" content=\"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep\" \/>\n<meta property=\"og:description\" content=\"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Execute Step\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-04T06:13:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-04T06:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Henrique\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Henrique\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/\"},\"author\":{\"name\":\"Henrique\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"headline\":\"ACCOUNT_STATUS no Oracle: o que significa cada valor\",\"datePublished\":\"2026-06-04T06:13:12+00:00\",\"dateModified\":\"2026-06-04T06:13:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/\"},\"wordCount\":839,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/dba_users-1.png\",\"keywords\":[\"dba_users\",\"lab\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/\",\"name\":\"ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/dba_users-1.png\",\"datePublished\":\"2026-06-04T06:13:12+00:00\",\"dateModified\":\"2026-06-04T06:13:13+00:00\",\"description\":\"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#primaryimage\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/dba_users-1.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/dba_users-1.png\",\"width\":1536,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/oracle\\\/account-status-oracle-dba-users\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ACCOUNT_STATUS no Oracle: o que significa cada valor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#website\",\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/\",\"name\":\"Execute Step\",\"description\":\"Execute with precision. Step by step.\",\"publisher\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/#\\\/schema\\\/person\\\/7e854882e27693a21f607693465d95aa\",\"name\":\"Henrique\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"url\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"contentUrl\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\",\"width\":182,\"height\":173,\"caption\":\"Henrique\"},\"logo\":{\"@id\":\"https:\\\/\\\/executestep.com\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/logo_autor.png\"},\"sameAs\":[\"https:\\\/\\\/executestep.com\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/henrique-soares-da-silva\\\/\",\"#\"],\"url\":\"https:\\\/\\\/executestep.com\\\/pt-br\\\/author\\\/ricuxo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep","description":"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/","og_locale":"pt_BR","og_type":"article","og_title":"ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep","og_description":"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.","og_url":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/","og_site_name":"Execute Step","article_published_time":"2026-06-04T06:13:12+00:00","article_modified_time":"2026-06-04T06:13:13+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png","type":"image\/png"}],"author":"Henrique","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Henrique","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#article","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/"},"author":{"name":"Henrique","@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"headline":"ACCOUNT_STATUS no Oracle: o que significa cada valor","datePublished":"2026-06-04T06:13:12+00:00","dateModified":"2026-06-04T06:13:13+00:00","mainEntityOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/"},"wordCount":839,"commentCount":0,"publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png","keywords":["dba_users","lab"],"articleSection":["Oracle"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/","url":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/","name":"ACCOUNT_STATUS Oracle: Todos os Valores | ExecuteStep","isPartOf":{"@id":"https:\/\/executestep.com\/pt-br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#primaryimage"},"image":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#primaryimage"},"thumbnailUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png","datePublished":"2026-06-04T06:13:12+00:00","dateModified":"2026-06-04T06:13:13+00:00","description":"Entenda cada valor do ACCOUNT_STATUS em DBA_USERS, de OPEN a LOCKED(TIMED) e IN ROLLOVER, com a causa e como reproduzir cada caso em lab.","breadcrumb":{"@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#primaryimage","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/06\/dba_users-1.png","width":1536,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/executestep.com\/pt-br\/oracle\/account-status-oracle-dba-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/executestep.com\/pt-br\/"},{"@type":"ListItem","position":2,"name":"ACCOUNT_STATUS no Oracle: o que significa cada valor"}]},{"@type":"WebSite","@id":"https:\/\/executestep.com\/pt-br\/#website","url":"https:\/\/executestep.com\/pt-br\/","name":"Execute Step","description":"Execute with precision. Step by step.","publisher":{"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/executestep.com\/pt-br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/executestep.com\/pt-br\/#\/schema\/person\/7e854882e27693a21f607693465d95aa","name":"Henrique","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","url":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","contentUrl":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png","width":182,"height":173,"caption":"Henrique"},"logo":{"@id":"https:\/\/executestep.com\/wp-content\/uploads\/2026\/02\/logo_autor.png"},"sameAs":["https:\/\/executestep.com","https:\/\/www.linkedin.com\/in\/henrique-soares-da-silva\/","#"],"url":"https:\/\/executestep.com\/pt-br\/author\/ricuxo\/"}]}},"_links":{"self":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/9306","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/comments?post=9306"}],"version-history":[{"count":2,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/9306\/revisions"}],"predecessor-version":[{"id":9314,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/posts\/9306\/revisions\/9314"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media\/9312"}],"wp:attachment":[{"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/media?parent=9306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/categories?post=9306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/executestep.com\/pt-br\/wp-json\/wp\/v2\/tags?post=9306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}