WRITE/USAGE stage privileges: Directory table refreshes allowed

Attention

This behavior change is in the 2023_06 bundle.

For the current status of the bundle, refer to Bundle History.

In the current Snowflake release, privileges on internal and external stages have changed as follows:

Previously:

To refresh the metadata for a directory table on a stage using an ALTER STAGE … REFRESH statement, a user must be granted or inherit the OWNERSHIP privilege.

Currently:

Users who have been granted or who inherit the following privileges will have the ability to refresh the metadata for a directory table:

  • WRITE on internal stages.

  • USAGE on external stages.

Ref: 1222

Language: English