From: Teja Jakkidi <teja.jakkidi05@gmail.com>
To: Ankur Kaushik <ankurkaushik@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: user permission denied for schema
Date: Mon, 30 Jan 2023 18:11:21 -0800
Message-ID: <931FA0FE-62CE-43F4-828F-C13F6BA4D664@gmail.com> (raw)
In-Reply-To: <CALXoLqx3we1xWccpkCbbdWeRSrso6W_qQxf3VzdGMWfadAv7sQ@mail.gmail.com>
References: <CALXoLqx3we1xWccpkCbbdWeRSrso6W_qQxf3VzdGMWfadAv7sQ@mail.gmail.com>
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
>
>
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: pgsql-admin@postgresql.org
Cc: teja.jakkidi05@gmail.com, ankurkaushik@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: user permission denied for schema
In-Reply-To: <931FA0FE-62CE-43F4-828F-C13F6BA4D664@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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