Home > mailing lists

user permission denied for schema - Mailing list pgsql-admin

From	Ankur Kaushik
Subject	user permission denied for schema
Date	January 31, 2023 05:08:33
Msg-id	CALXoLqx3we1xWccpkCbbdWeRSrso6W_qQxf3VzdGMWfadAv7sQ@mail.gmail.com Whole thread Raw
Responses	Re: user permission denied for schema
List	pgsql-admin

Hi,

I am trying to select records from table for other schema but unable to fetch due to permission denied error

GRANT SELECT ON ALL TABLES IN SCHEMA condenastvms_uat TO edw;

sdp_edw=> select count(*) from condenastvms_uat.activity_logs;

ERROR: permission denied for schema condenastvms_uat

LINE 1: select count(*) from condenastvms_uat.activity_logs;

Regards

Ankur

From: Abhishek Singh
Date: 31 January 2023, 02:02:32
Subject: Re: Foreign key creation on table with huge record count.

From: Teja Jakkidi
Date: 31 January 2023, 05:11:21
Subject: Re: user permission denied for schema