utl_smtp
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: utl_smtp

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    Hi everybody,

    with the user sys I am able to send the mail thru utl_smtp.My prob is when i connected to the some other user say abc i am getting the errors it says insufficient priviledges.I just want to know what are the previledges i have to grant to the user abc in order to execute the utl_smtp.what are the steps in order to run the utl_smtp from the user other than sys.do i have to run all the scripts again in the user abc.

    thanks in advance
    pras

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    There are no special priveleges to be given to access the utl_smtp package.You need to give execute priveleges for the user abc on the package/procedure you created.Thats it

    Regards,
    Rohit Nirkhe,Oracle /APPS DBA,Oracle 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width