[oracle] install and grant access to UTLMAIL, UTLSMTP, UTLFILE

DOS naja

C:\Users\User>cd C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin>sqlplus / as sysdba

Then

SQL> @utlmail
SQL> @utlsmtp
SQL> @utlfile
SQL> grant execute on utl_mail to username_naja;
SQL> grant execute on utl_smtp to username_naja;
SQL> grant execute on utl_file to username_naja;

ref : blogdaprima

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s