TRUSTED/UNTRUSTED keyword in oracle statements

user_10137959 0
Viewed 101

Can anyone tell me about the trusted/untrusted keyword in the below statements? These statements are working on Oracle without any problem. But I can't find TRUSTED/UNTRUSTED keyword in their grammar documentation.

SQL> CREATE OR REPLACE NONEDITIONABLE LIBRARY LIBRARY_EXAMPLE TRUSTED AS STATIC;
  2  /

Library created.

SQL>  CREATE OR REPLACE NONEDITIONABLE LIBRARY LIBRARY_EXAMPLE_2 UNTRUSTED AS STATIC;
  2  /

Library created.
oracle12c oracle
1 Answers

Remove them.

If they are not listed in the Docs, and they are NOT, then they are not supported. You don't want unsupported code running in production.

An interesting exercise, ask the developer who wrote that code, why they added those keywords. What were they trying to solve, fix, build.

user_11564520
Related