Lists every principal that holds a privilege on a given external location.
SHOW GRANTS ON EXTERNAL LOCATION <name>## Overview SHOW GRANTS ON EXTERNAL LOCATION returns every grant currently recorded against the named location. ## Output Columns include the privilege, the principal, whether WITH GRANT OPTION applies, the granter, and the granted timestamp. ## Access Control Requires the `ManageGrants` privilege on the location. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
location_name | Specifies the external location. |
SHOW GRANTS ON EXTERNAL LOCATION raw_data;