From: | Ankur Kaushik <ankurkaushik(at)gmail(dot)com> |
---|---|
To: | Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: user permission denied for schema |
Date: | 2023-01-31 07:15:50 |
Message-ID: | CALXoLqwurztqLVL5-tRePG4M_dN7RjGNy+TUeUNkFO02J8U+ng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks Teja Its Working now
On Tue, Jan 31, 2023 at 7:41 AM Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)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(at)gmail(dot)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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rakesh Nashine | 2023-02-01 14:38:37 | Role Does Not exist post server reboot |
Previous Message | Teja Jakkidi | 2023-01-31 02:11:21 | Re: user permission denied for schema |