CODEWITHSUNDEEP
amazon-redshift
Ganesh Pitchai
Ganesh Pitchai

Reputation: 55

Access denied when table is recreated in Redshift

I created a new user and gave read-only access to the user for all the schemas with:

alter default privileges grant select on tables to the user;

Initially, the user had access but when the table was recreated the access automatically declined.

Why is this happening?

Upvotes: 0

Views: 694

Answers (1)

Sharath
Sharath

Reputation: 61

How you are giving permission? Group level or User level.

Try below GRANT USAGE

For Group level 

GRANT USAGE ON SCHEMA 'SCHEMA_NAMES' TO GROUP Group_name;

For User level

GRANT USAGE ON SCHEMA 'SCHEMA_NAMES' TO USER User_name;

Upvotes: 1

Related Questions