public inbox for [email protected]  
help / color / mirror / Atom feed
From: Karki, Sanjay <[email protected]>
To: [email protected] <[email protected]>
Subject: PG catalog
Date: Thu, 23 May 2024 22:01:41 +0000
Message-ID: <PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com> (raw)

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:[email protected]]

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

Follow the NAIC on
[cid:[email protected]]<https://www.facebook.com/NAIC.News; [cid:[email protected]] <https://twitter.com/NAIC;  [cid:[email protected]] <https://www.youtube.com/user/NAICCommunications;  [cid:[email protected]] <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 [email protected].


Attachments:

  [image/png] image001.png (5.4K, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/3-image001.png)
  download | view image

  [image/png] image002.png (663B, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/4-image002.png)
  download | view image

  [image/png] image003.png (564B, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/5-image003.png)
  download | view image

  [image/png] image004.png (598B, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/6-image004.png)
  download | view image

  [image/png] image005.png (637B, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/7-image005.png)
  download | view image

  [image/png] postgreserror.png (73.1K, ../PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com/8-postgreserror.png)
  download | view image

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: PG catalog
  In-Reply-To: <PH0PR22MB3882F0C784A6AC48800C0BEEA2F42@PH0PR22MB3882.namprd22.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox