Categories:: System functions (System Control)

SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS¶

Stops record collection of network access attempts to internal stage locations for this account. You can view these records in the INTERNAL_STAGE_NETWORK_ACCESS_HISTORY view.

See also:: SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS

Syntax¶

SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS()

Copy

Arguments¶

None.

Returns¶

Returns a VARCHAR status message, which states that record collection of network access attempts to internal stage locations has ended.

Access control requirements¶

Only account administrators (users with the ACCOUNTADMIN role) can execute this function.

Usage notes¶

Latency between running this function and stopping record collection is up to 6 hours.

Example¶

Stop record collection of network access attempts to internal stage locations for this account:

USE ROLE ACCOUNTADMIN;
SELECT SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS();

Copy

+--------------------------------------------------------------------+
| Record collection has been successfully disabled for this account. |
+--------------------------------------------------------------------+