-
Title
Cannot install Private Repository without ACL setup. -
Description
When trying to setup Private script repository in a database (View | Toad options | Online | Script Repository | Private) a ORA-00942 error is given after providung SMTP info.
Toad runs the following and b/c ACL is not set up on the database, this error is encountered.
select acl
from dba_network_acls
where acl = '/sys/acls/mail_access.xml'Error occurred: [942] (ORA-00942: table or view does not exist)
The database is not set up with ACL and XML DB. Can a Toad private script repository be installed without installing ACLS /XMLDB? Is it possible to skip that mail server checking?
-
Cause
Toad repository requires email capabilities on the server that the repository is set up on. ACL is needed for email capabilities.
-
Resolution
Please install ACL/XML DB in order to work with Private Script Repository feature in Toad.