SHOW Commands: New OWNER_ROLE_TYPE Column in Output¶
This behavior change is in the 2023_04 bundle.
For the current status of the bundle, refer to Bundle History.
The OWNER_ROLE_TYPE column is included in the output of the following SHOW <object_type> commands:
SHOW EXTERNAL TABLES
SHOW FILE FORMATS
SHOW MASKING POLICIES
SHOW MATERIALIZED VIEWS
SHOW ROW ACCESS POLICIES
The column displays the type of role that owns the object: ROLE or DATABASE_ROLE.