How can I allow Amazon Redshift database regular users permission to view data in system tables from other users for my cluster?
I am not able to view data generated by other users in system tables in my Amazon Redshift cluster. How can I view the tables?
"I am not able to view data generated by other users in system tables in my Amazon Redshift cluster. How can I view the tables?Short descriptionBy default, Amazon Redshift regular users don't have permission to view data from other users. Only Amazon Redshift database superusers have permission to view all databases.ResolutionYou can add the SYSLOG ACCESS parameter with UNRESTRICTED access for the regular user to view data generated by other users in system tables.Note: Regular users with SYSLOG ACCESS can't view superuser tables. Only superusers can view other superuser tables.1.    Connect to the Amazon Redshift database as a superuser.2.    Run the SQL command ALTER USER similar to the following:test=# ALTER USER testuser WITH SYSLOG ACCESS UNRESTRICTED;ALTER USERNote: The required privileges for ALTER USER are superuser, users with the ALTER USER privilege, and users that want to change their own passwords.The regular user now has SYSLOG ACCESS with UNRESTRICTED access.3.    Disconnect from the Amazon Redshift database as the superuser.4.    Connect to the Amazon Redshift database as the regular user that has SYSLOG ACCESS with UNRESTRICTED access.5.    Test the regular users access by running a SQL command similar to the following:test=> select * from stv_inflight;-[ RECORD 1 ]--------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------userid                     | 100slice                      | 12811query                      | 3036label                      | default                                  xid                        | 35079530pid                        | 1073746910starttime                  | 2022-09-15 07:09:15.894317text                       | select * from my_schema.dw_lu_tiers_test a, my_schema.dw_lu_tiers_test;                                suspended                  | 0insert_pristine            | 0concurrency_scaling_status | 0-[ RECORD 2 ]--------------+---------------------------------------------------------------------------------------------------------------------------------------------------userid                     | 181slice                      | 12811query                      | 3038label                      | defaultxid                        | 35079531pid                        | 1073877909starttime                  | 2022-09-15 07:09:17.694285text                       | select * from stv_inflight;                                                                            suspended                  | 0insert_pristine            | 0concurrency_scaling_status | 0In the example output, note that the regular user now has access to view another users table.Follow"