SHOW Commands: New OWNER_
Attention
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 OBJECTS
- SHOW PIPES
- SHOW ROW ACCESS POLICIES
- SHOW SCHEMAS
- SHOW SEQUENCES
- SHOW STAGES
- SHOW STREAMS
- SHOW TABLES
- SHOW TAGS
- SHOW TASKS
- SHOW VIEWS
The column displays the type of role that owns the object: ROLE or DATABASE_ROLE.
Ref: 747