Lists every principal that holds a privilege on a given storage credential.
SHOW GRANTS ON STORAGE CREDENTIAL <name>## Overview SHOW GRANTS ON STORAGE CREDENTIAL returns every grant currently recorded against the named credential. ## Output Columns include the privilege, the principal, whether WITH GRANT OPTION applies, the granter, and the granted timestamp. No secret material is returned. ## Access Control Requires the `ManageGrants` privilege on the credential. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
credential_name | Specifies the storage credential. |
SHOW GRANTS ON STORAGE CREDENTIAL prod_aws_role;