snipt

Ctrl+h for KB shortcuts

SQL

Activate HR user in Oracle

1
2
3
4
5
alter user hr identified by hr account unlock;

/*
Enter HR_ORCL for the Connection Name (or any other name that identifies your connection), hr for the Username and Password, specify your localhost for the Hostname and enter ORCL for the SID. Click Test.
*/
https://snipt.net/embed/6ef757aee1f1d547d692061435e028c7/
/raw/6ef757aee1f1d547d692061435e028c7/
6ef757aee1f1d547d692061435e028c7
sql
SQL
5
2019-08-20T20:27:27
True
False
False
/api/public/snipt/41621/
activate-hr-user-in-oracle
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1">1</a> <a href="#L-2">2</a> <a href="#L-3">3</a> <a href="#L-4">4</a> <a href="#L-5">5</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="k">alter</span> <span class="k">user</span> <span class="n">hr</span> <span class="n">identified</span> <span class="k">by</span> <span class="n">hr</span> <span class="n">account</span> <span class="n">unlock</span><span class="p">;</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="cm">/*</span> </span><span id="L-4"><a name="L-4"></a><span class="cm">Enter HR_ORCL for the Connection Name (or any other name that identifies your connection), hr for the Username and Password, specify your localhost for the Hostname and enter ORCL for the SID. Click Test.</span> </span><span id="L-5"><a name="L-5"></a><span class="cm">*/</span> </span></pre></div> </td></tr></table>
oracle, pl/sql