- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
I recommend you open Support Ticket so this issue gets looked into officially.
Hi Sumeet,
Some SVV tables and views return empty result if the user does not have permissions on the objects (in your case the test_table_* tables), even if the user has SYSLOG ACCESS UNRESTRICTED. If you grant access (for example, SELECT) on the table to user_access_test_user, then this should work.
Regards,
Thank you for the suggestion, granting
SELECT
on the table makes it appear in theSVV_REDSHIFT_TABLES
. However, theuser_access_test_user
user is created for and used by the monitoring service. Our internal policies do not allow the monitoring system user to haveSELECT
access to the tables, thus the issue.
Currently, Super users can see all the data and regular users can see their own data in SVV_REDSHIFT_TABLES[1]. To query complete data in the SVV_REDSHIFT_TABLES or SVV_ALL_TABLES tables, you require Super user or provide access[2] on the table for normal user.
SYSLOG ACCESS UNRESTRICTED is used to view the data of other user queries in query monitoring tables(ex: svv_tansactions, stv_recents) when other users are running queries on Redshift cluster. Privileges to access for each system table may vary when the querying user is non-super user.
[1] https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_REDSHIFT_TABLES.html
[2] GRANT: https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 3 anni fa
We opened a support ticket, and will post an update here once we have any response