PG catalog
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.png@HNMW31RS4NU4.A9W7106ZTAI5]
O: 816-783-8718
M: 816-394-4383
W: www.naic.org<https://www.naic.org>
Follow the NAIC on
[cid:image002.png@HNMW31RS4NU4.A9W7106ZTAI5]<https://www.facebook.com/NAIC.News> [cid:image003.png@HNMW31RS4NU4.A9W7106ZTAI5] <https://twitter.com/NAIC> [cid:image004.png@HNMW31RS4NU4.A9W7106ZTAI5] <https://www.youtube.com/user/NAICCommunications> [cid:image005.png@HNMW31RS4NU4.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@naic.org.
On Thursday, May 23, 2024, Karki, Sanjay <skarki@naic.org> wrote:
I need to grant select on privilege in pg_catalog to user so I can connect
via Toad Data point ,Users can already select from the tables in pg_catalog, grant able
privileges not required or allowed. Of course, some specific data is
restricted from non-superusers.
David J.
"Karki, Sanjay" <skarki@naic.org> writes:
I need to grant select on privilege in pg_catalog to user so I can connect via Toad Data point ,
Why do you think you need to do that? Most catalogs have public
select privilege already, and for the ones that don't, there are
very good reasons why not. I don't know what "Toad Data point"
is, but if it thinks it needs more privilege than is normally
granted, you should be asking very pointed questions about why
and why that shouldn't be considered a security breach.
(Usually we get complaints that the default permissions on the
catalogs are too loose, not too tight.)
regards, tom lane