PG catalog

From: "Karki, Sanjay" <skarki(at)naic(dot)org>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: PG catalog
Date: 2024-05-23 22:01:41
Message-ID: PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi ,

I need to grant select on privilege in pg_catalog to user so I can connect via Toad Data point ,

I tried by
grant select on all tables in schema pg_catalog to group sys;
while connecting as sys.

But it throws me error

grant select on all tables in schema pg_catalog to sys ;

ERROR: permission denied for table pg_statistic SQL state: 42501

Can I get some help please

Thank you

Sanjay karki

Sanjay Karki

Database Administrator III

ITG

[cid:image001(dot)png(at)HNMW31RS4NU4(dot)A9W7106ZTAI5]

O: 816-783-8718
M: 816-394-4383
W: www.naic.org<https://www.naic.org>

Follow the NAIC on
[cid:image002(dot)png(at)HNMW31RS4NU4(dot)A9W7106ZTAI5]<https://www.facebook.com/NAIC.News> [cid:image003(dot)png(at)HNMW31RS4NU4(dot)A9W7106ZTAI5] <https://twitter.com/NAIC> [cid:image004(dot)png(at)HNMW31RS4NU4(dot)A9W7106ZTAI5] <https://www.youtube.com/user/NAICCommunications> [cid:image005(dot)png(at)HNMW31RS4NU4(dot)A9W7106ZTAI5] <https://www.linkedin.com/company/naic/>

--------------------------------------------------

CONFIDENTIALITY NOTICE

--------------------------------------------------

This message and any attachments are from the NAIC and are intended only for the addressee. Information contained herein is confidential, and may be privileged or exempt from disclosure pursuant to applicable federal or state law. This message is not intended as a waiver of the confidential, privileged or exempted status of the information transmitted. Unauthorized forwarding, printing, copying, distribution or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or by forwarding it to the NAIC Service Desk at help(at)naic(dot)org(dot)

Attachment Content-Type Size
image/png 73.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2024-05-23 22:08:11 Re: DROP OWNED BY fails to clean out pg_init_privs grants
Previous Message Ilya Gladyshev 2024-05-23 21:14:57 Re: CREATE INDEX CONCURRENTLY on partitioned index