- Schema:
SESSION_POLICIES View¶
This Account Usage view provides the session policies in your account.
Each row in this view corresponds to a different session policy.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
NAME |
TEXT |
Name of the policy. |
ID |
NUMBER |
Internal/system-generated identifier for the session policy. |
NAME |
TEXT |
Name of the session policy. |
SCHEMA_ID |
TEXT |
Internal/system-generated identifier for the schema in which the policy resides. |
SCHEMA |
TEXT |
Schema to which the session policy belongs. |
DATABASE_ID |
TEXT |
Internal/system-generated identifier for the database in which the policy resides. |
DATABASE |
TEXT |
Database to which the session policy belongs. |
OWNER |
TEXT |
Name of the role that owns the session policy. |
OWNER_ROLE_TYPE |
TEXT |
The type of role that owns the object, either |
SESSION_IDLE_TIMEOUT_MINS |
INT |
Session idle timeout in minutes for the policy. |
SESSION_UI_IDLE_TIMEOUT_MINS |
INT |
UI session idle timeout in minutes for the policy. |
COMMENT |
TEXT |
Comments entered for the session policy (if any). |
CREATED |
TIMESTAMP_LTZ |
Date and time when the session policy was created. |
LAST_ALTERED |
TIMESTAMP_LTZ |
Date and time when the session policy was last altered. |
DELETED |
TIMESTAMP_LTZ |
Date and time when the session policy was dropped. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).