Error, "The EXECUTE privilege on Oracle's UTL_FILE package is required to load the alert log." (4229730)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error, "The EXECUTE privilege on Oracle's UTL_FILE package is required to load the alert log."
Description

When loading the alert log in Toad for Oracle, the following error occurs:
The EXECUTE privilege on Oracle's UTL_FILE package is required to load the alert log
Cause

Insufficiant permissions to UTL_FILE Oracle package.
Resolution

Alert logs require this UTL_FILE package in order to read them. It's not defaulted to users, so it has to be assigned. Run the following command:

GRANT EXECUTE ON SYS.UTL_FILE TO <user name>;
Additional Information

Oracle Doc on the UTL_FILE package: http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21645/u_file.htm

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title