amazon-web-services - Redshift - 视图的访问控制

Question

我在设置查看访问控制权限时遇到问题。

我有以下表格和视图。

员工 - 表

first_name varchar(50)
last_name varchar(50)
telehone_number varchar(50)

employee_view -查看 相同的列

first_name varchar(50)
last_name varchar(50)
telehone_number varchar(50)

User1：它可以访问first_name和 last_name列。

但是，如果我尝试提供User1对相同列的访问，则会employee_view出现以下错误。而且我什至无法在视图中访问此列。它给了我permission denied错误。

错误

OK. No rows were affected
SQLWarning: 
1) SQL State: 01000 --- The SELECT privilege on employee_view.first_name was not granted to user user1 as the grantee holds this privilege at the relation level.Revoke the relation level privilege before granting column privileges.
2) SQL State: 01000 --- The SELECT privilege on employee_view.last_name was not granted to user user1 as the grantee holds this privilege at the relation level.Revoke the relation level privilege before granting column privileges.

更新：

我usage授予模式。但是，我仍然遇到同样的错误

grant usage on schema public to user1;

标签： amazon-web-servicesamazon-redshift