SHOW Commands: New OWNER_ROLE_TYPE Column in Output¶
This behavior change is in the 2023_02 bundle.
For the current status of the bundle, refer to Bundle History.
The OWNER_ROLE_TYPE column is now included in the output of the following SHOW <objects> commands:
SHOW EXTERNAL TABLES
SHOW FILE FORMATS
SHOW MASKING POLICIES
SHOW MATERIALIZED VIEWS
SHOW ROW ACCESS POLICIES
The column shows the type of role that owns the object: ROLE or DATABASE_ROLE. The new column has be added immediately after the existing OWNER column.