Sample Header Ad - 728x90

User has more privileges in redshift than shown by relevant query

1 vote
1 answer
387 views
Working in Redshift
dev=# SELECT table_catalog, table_schema, table_name, privilege_type
FROM   information_schema.table_privileges
WHERE  grantee = 'myser';
 table_catalog | table_schema | table_name | privilege_type
---------------+--------------+------------+----------------
(0 rows)
However the user is able to perform select on several randomly tested pg_catalog schema tables, e.g. SELECT * FROM pg_class_info;, SELECT * FROM pg_class; etc. The only GRANT command I run after creating myser was:
GRANT SELECT ON stl_connection_log  TO myuser;
after setting
SET search_path TO pg_catalog;
what am I missing?
Asked by pkaramol (213 rep)
Feb 24, 2021, 03:32 PM
Last activity: Apr 14, 2025, 05:06 PM