Amazon Redshift system-defined roles

Question

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.

Accepted Answer

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

Amazon Redshift system-defined roles

Relevant content