+ New Ticket

Articles in this section

See more

Database browser error [Amazon](500310) Invalid operation: permission denied for relation pg_user_info

Avatar
Eli Weine
  • Updated

After connecting to Redshift, some users are reporting seeing the below error when trying to browse the catalog.

We are aware of this issue and are actively working on an update to Aginity Pro so this permission is not necessary. In the meantime, please see the workaround listed below.

 

Workaround:  A DBA should grant select on table pg_user_info to the group your user is in

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Was this article helpful?
0 out of 0 found this helpful
Return to top

Related articles