STORAGE_POLICIES
Monitors the current storage policies in effect for one or more database objects.
Monitors the current storage policies in effect for one or more database objects.
| Column Name | Data Type | Description |
|---|---|---|
SCHEMA_NAME |
VARCHAR | Schema name for which information is listed. |
OBJECT_NAME |
VARCHAR | The name of the database object associated through the storage policy. |
POLICY_DETAILS |
VARCHAR | The object type of the storage policy. |
LOCATION_LABEL |
VARCHAR (128) | The label for this storage location. |
Privileges
Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.