Categories:: System functions (System Control)

SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS¶

Starts 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_OUT_INTERNAL_STAGE_NETWORK_LOGS

Syntax¶

SYSTEM$OPT_IN_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 been enabled.

Access control requirements¶

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

Usage notes¶

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

Example¶

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

USE ROLE ACCOUNTADMIN;
SELECT SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS();

Copy

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