Amazon Redshift system-defined roles
0
Hi, I have assigned a system defined role "Sys:dba" to a user, but this role has no permissions.
I have used: GRANT ROLE sys:dba to "user";
According to the documentation. https://docs.aws.amazon.com/redshift/latest/dg/r_roles-default.html this role should have permissions,
but by using the command:
SELECT namespace_name AS schema_name, relation_name AS table_name, privilege_type, identity_name AS role_name
FROM svv_relation_privileges
WHERE role_name = 'sys:dba'
I see that it does not have any permissions.
These roles are only sample roles?
Thank you very much for your help.
質問済み 8ヶ月前352ビュー
1回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
Please use following query to identify system privileges for System roles.
SELECT system_privilege,identity_name,identity_type FROM svv_system_privileges where identity_name = 'sys:dba';
For additional information please refer https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_SYSTEM_PRIVILEGES.html
Thank you for your comment. I thought these roles had other permissions, now it's clearer!