ERROR: permission denied for relation svl_user_info in redshift

0

Hi I am trying to access the svl_user_info table using the super user but still I am facing the permission denied error.

Same Way I am facing the error in Redshift also ( server one).Here user is not the admin. Which role user should have to access the select * from svl_user_info ;

Venkat
已提问 7 个月前770 查看次数
2 回答
0

Hello.

In Amazon Redshift, the svl_user_info is a system view that provides details about user sessions on the database. If you're encountering permission errors when trying to access this view, it typically indicates insufficient permissions.

Here are the steps to address the issue:

  • Superuser Access: First, ensure you truly have superuser access. Superusers in Redshift should have access to all tables and views. If you're logged in as a superuser and still facing this issue, there might be an unexpected configuration or a Redshift bug.

  • GRANT Permissions: If you're not a superuser or want to grant another user access to the svl_user_info view, you can provide the necessary permissions using the following SQL command:

GRANT SELECT ON svl_user_info TO [username];

Regards, Andrii

profile picture
专家
已回答 7 个月前
0

Hi Venkat,

Are you using a Redshift provisioned cluster or a Redshift serverless endpoint?

SVL_USER_INFO is a system view that can be queried on provisioned clusters only.

You can use SVV_USER_INFO instead.

Regards,

AWS
专家
Ziad
已回答 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则