AWS redshift documentation change
Summary
Expanded SHOW TABLES output columns and updated examples to include table ACL details, ownership, timestamps, and filtering
Security assessment
The change adds documentation about table ACLs (access control lists) showing granular permissions (e.g., 'alice=arwdRxtDPA/alice~bob=d/alice'), which helps users understand access control mechanisms. However, there's no evidence this addresses a specific security vulnerability.
Diff
diff --git a/redshift/latest/dg/r_SHOW_TABLES.md b/redshift/latest/dg/r_SHOW_TABLES.md index 6cefb9b03..9ea621b28 100644 --- a//redshift/latest/dg/r_SHOW_TABLES.md +++ b//redshift/latest/dg/r_SHOW_TABLES.md @@ -13 +13,3 @@ Shows a list of tables in a schema, along with some table attributes. -Each output row consists of database name, schema name, table name, table type, table ACL, and remarks. For more information about these attributes, see [SVV_ALL_TABLES](./r_SVV_ALL_TABLES.html). +Each output row consists of database name, schema name, table name, table type, table ACL, remarks, table owner, last altered time, last modified time, dist_style, and table sub-type. For more information about these attributes, see [SVV_ALL_TABLES](./r_SVV_ALL_TABLES.html). + +The modification and alteration timestamps can lag behind the table updates by approximately 5 minutes. @@ -70,4 +71,0 @@ The maximum number of rows to return. The _row_limit_ can be 0–10,000. -Following example shows the tables in the Amazon Redshift database named `dev` that are in schema `public`. - - - SHOW TABLES FROM SCHEMA dev.public; @@ -75,5 +73 @@ Following example shows the tables in the Amazon Redshift database named `dev` t - database_name | schema_name | table_name | table_type | table_acl | remarks - ---------------+-------------+------------+------------+-----------+--------- - dev | public | tb | TABLE | | - dev | public | tb2 | TABLE | | - dev | public | tb3 | TABLE | | + SHOW TABLES FROM SCHEMA s1; @@ -80,0 +75,6 @@ Following example shows the tables in the Amazon Redshift database named `dev` t + database_name | schema_name | table_name | table_type | table_acl | remarks | owner | last_altered_time | last_modified_time | dist_style | table_subtype + ---------------+-------------+-------------------+------------+-------------------------------------+---------+-------+----------------------------+----------------------------+------------+------------------- + dev | s1 | late_binding_view | VIEW | alice=arwdRxtDPA/alice~bob=d/alice | | alice | | | | LATE BINDING VIEW + dev | s1 | manual_mv | VIEW | alice=arwdRxtDPA/alice~bob=P/alice | | alice | | | | MATERIALIZED VIEW + dev | s1 | regular_view | VIEW | alice=arwdRxtDPA/alice~bob=r/alice | | alice | | | | REGULAR VIEW + dev | s1 | test_table | TABLE | alice=arwdRxtDPA/alice~bob=rw/alice | | alice | 2025-11-18 15:52:00.010452 | 2025-11-18 15:44:34.856073 | AUTO (ALL) | REGULAR TABLE @@ -82 +81,0 @@ Following example shows the tables in the Amazon Redshift database named `dev` t -Following example shows the tables in the AWS Glue Data Catalog database named `awsdatacatalog` that are in schema `batman`. @@ -85 +84 @@ Following example shows the tables in the AWS Glue Data Catalog database named ` - SHOW TABLES FROM SCHEMA awsdatacatalog.batman; + SHOW TABLES FROM SCHEMA dev.s1 LIKE '%view' LIMIT 1; @@ -87,8 +86,3 @@ Following example shows the tables in the AWS Glue Data Catalog database named ` - database_name | schema_name | table_name | table_type | table_acl | remarks - ----------------+-------------+------------------+------------+-----------+--------- - awsdatacatalog | batman | nation | EXTERNAL | | - awsdatacatalog | batman | part | EXTERNAL | | - awsdatacatalog | batman | partsupp | EXTERNAL | | - awsdatacatalog | batman | region | EXTERNAL | | - awsdatacatalog | batman | supplier | EXTERNAL | | - awsdatacatalog | batman | automount_nation | EXTERNAL | | + database_name | schema_name | table_name | table_type | table_acl | remarks | owner | last_altered_time | last_modified_time | dist_style | table_subtype + ---------------+-------------+-------------------+------------+--------------------------------------+---------+-------+-------------------+--------------------+------------+------------------- + dev | s1 | late_binding_view | VIEW | {alice=arwdRxtDPA/alice,bob=d/alice} | | alice | | | | LATE BINDING VIEW