PL/SQL (MOSC)

MOSC Banner

What triggers an ora-00942 when executing “grant execute on ‘SYS’.UTL_MAIL to public;”

edited Jun 24, 2025 11:42AM in PL/SQL (MOSC) 2 commentsAnswered ✓

We wanted to configure the mailing on our newly installed database 21c.

-- Instructions

@$ORACLE_HOME/rdbms/admin/utlmail.sql
@$ORACLE_HOME/rdbms/admin/prvtmail.plb

ALTER SYSTEM SET smtp_out_server = ‘smtpout.basf.net:25’ SCOPE=both;

-- ACLs have also been configured

A test mail with the sys user works without any problems.

But when we want to set up the authorization for other users, we get an error:

grant execute on "SYS".UTL_MAIL to public;
ORA-00942: Table or view does not exist

https://docs.oracle.com/error-help/db/ora-00942/00942. 00000 - "table or view%s does not exist"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center