datashare_break_glass_session_var
Values (default in bold)
There is no default. The value can be any character string generated by Amazon Redshift when an operation occurs that isn't recommended, as described following.
Description
Applies a permission that allows certain operations that generally aren't recommended for an Amazon Web Services Data Exchange datashare.
In general, we recommend that you don't drop or alter an Amazon Web Services Data Exchange datashare using
the DROP DATASHARE or ALTER DATASHARE SET PUBLICACCESSIBLE statement. To allow dropping
or altering an Amazon Web Services Data Exchange datashare to turn off the publicly accessible setting, set the
datashare_break_glass_session_var
variable to a one-time value. This
one-time value is generated by Amazon Redshift and provided in an error message after the
initial attempt at the operation in question.
After setting the variable to the one-time generated value, run the DROP DATASHARE or ALTER DATASHARE statement again.
For more information, see ALTER DATASHARE usage notes or DROP DATASHARE usage notes.
Example
set datashare_break_glass_session_var to '620c871f890c49';