grant permission for dbms_crypto
<p>I am using dbms_crypto.encrypt function in my oracle procedure for encryption of passwords. I have connected to oracle as :</p>

<pre><code>connect sqlplus as sysdba
</code></pre>

<p>and then granted permission as :</p>

<pre><code>grant execute on sys.dbms_crypto to myuser;
</code></pre>

<p>And then i can use dbms_crypto in my procedure. But i would like to know how can i check in my database whether the permission are granted or not for dbms_crypto ? Because i have to use this procedure in another database and does not know whether that database has grant permission or not for dbms_crypto.</p>