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
Last activity: Apr 14, 2025, 05:06 PM