pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeduser permission denied for schema
3+ messages / 2 participants
[nested] [flat]
* user permission denied for schema
@ 2023-01-31 02:08 Ankur Kaushik <ankurkaushik@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ankur Kaushik @ 2023-01-31 02:08 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: user permission denied for schema
@ 2023-01-31 02:11 Teja Jakkidi <teja.jakkidi05@gmail.com>
parent: Ankur Kaushik <ankurkaushik@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Teja Jakkidi @ 2023-01-31 02:11 UTC (permalink / raw)
To: Ankur Kaushik <ankurkaushik@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Hello Kaushik,
Did you grant usage on schema to the user??
Grant usage on schema schemaname to username;
Thanks,
Teja. J.
> On Jan 30, 2023, at 6:08 PM, Ankur Kaushik <ankurkaushik@gmail.com> wrote:
>
>
>
> 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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: user permission denied for schema
@ 2023-01-31 07:15 Ankur Kaushik <ankurkaushik@gmail.com>
parent: Teja Jakkidi <teja.jakkidi05@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Ankur Kaushik @ 2023-01-31 07:15 UTC (permalink / raw)
To: Teja Jakkidi <teja.jakkidi05@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Thanks Teja Its Working now
On Tue, Jan 31, 2023 at 7:41 AM Teja Jakkidi <teja.jakkidi05@gmail.com>
wrote:
> Hello Kaushik,
>
> Did you grant usage on schema to the user??
>
> Grant usage on schema schemaname to username;
>
> Thanks,
> Teja. J.
>
> On Jan 30, 2023, at 6:08 PM, Ankur Kaushik <ankurkaushik@gmail.com> wrote:
>
>
>
> 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
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-01-31 07:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-31 02:08 user permission denied for schema Ankur Kaushik <ankurkaushik@gmail.com>
2023-01-31 02:11 ` Teja Jakkidi <teja.jakkidi05@gmail.com>
2023-01-31 07:15 ` Ankur Kaushik <ankurkaushik@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox