Re: postgres issue

\dn+ public                                            List of schemas            Name             |     Owner     |       Access privileges        |      Description-----------------------------+---------------+--------------------------------+-----------------------------------------public rdsadmin dailypay_root=UC/rdsadmin dailypay=U/rdsadmin    standard public schema

On Saturday, June 13, 2020, 05:12:32 PM CDT, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

On 6/13/20 2:52 PM, Shailesh Rangani wrote:
> + Community DL.
>
>
>
>
>
> On Saturday, June 13, 2020, 04:39:01 PM CDT, Shailesh Rangani
> <shailesh(dot)rangani(at)yahoo(dot)com> wrote:
>
>
> Hi Adrian,
>
> Please find the attached sequence.

Please post output of command below as text.

What does \dn+ public show?

>
> Regards
> Shailesh
>
>
>
>
>
> ------ Forwarded message ---------
>
> From: *Adrian Klaver* <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> Date: Sat, Jun 13, 2020 at 10:43 AM
> Subject: Re: Fwd: not able to give usage access to public schema
> To: sekhar chandra <sekharclouddbengineer(at)gmail(dot)com
> <mailto:sekharclouddbengineer(at)gmail(dot)com>>
> Cc: <pgsql-general(at)postgresql(dot)org <mailto:pgsql-general(at)postgresql(dot)org>>
>
>
>
> On 6/13/20 10:33 AM, sekhar chandra wrote:
>  > Adrian - when I follow the same steps what you did . in my case , the
>  > result is false.
>  >
>  >
>  > grant usage on schema public to role_test ;
>  > GRANT
>  >
>  > SELECT rolname, has_schema_privilege('role_test', 'public', 'usage')
>  > from pg_roles where rolname = 'role_test';
>  >     rolname  | has_schema_privilege
>  > -----------+----------------------
>  >    role_test | f
>
> Postgres version and where are you running this e.g. cloud service?
>
> What does \dn+ public show before and after you redo commands as asked
> below?
>
> Can you start over and provide complete sequence for above including
> CREATE ROLE and what user you are doing the above as?
>
>
>
>  >
>  > On Fri, Jun 12, 2020 at 10:11 PM Adrian Klaver
>  > <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>>
> wrote:
>  >
>  >     On 6/12/20 3:56 PM, sekhar chandra wrote:
>  >      > I am not able to give usage permission to public schema. below
>  >     are the
>  >      > steps.
>  >      >
>  >      >
>  >      > Logged in as super user
>  >      > created a new user as user1
>  >      > grant usage on public to user1
>  >
>  >     Either the above is a cut and paste error or you got an error:
>  >
>  >     grant usage on public to role_test ;
>  >     ERROR:  relation "public" does not exist
>  >
>  >     grant usage on schema public to role_test ;
>  >     GRANT
>  >
>  >     SELECT rolname, has_schema_privilege('role_test', 'public', 'usage')
>  >     from pg_roles where rolname = 'role_test';
>  >         rolname  | has_schema_privilege
>  >     -----------+----------------------
>  >        role_test | t
>  >
>  >
>  >      >
>  >      > command completed successfully , but verification statement
>  >     showing he
>  >      > doesnt have usage permission.
>  >      > SELECT rolname, has_schema_privilege(rolname, 'public', 'usage')
>  >     from
>  >      > pg_roles;
>  >      >
>  >      > this is strage. what could go wrong.
>  >
>  >
>  >     --
>  >     Adrian Klaver
>  > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>  >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
> //Datavail/Internal - Limited External Distribution
>
> This email (including any attachments) is for the use of the intended
> recipient(s) only and may contain confidential or proprietary
> information. If you have received this email in error, please notify the
> sender immediately and then delete it. If you are not the intended
> recipient, you must not keep, use, disclose, copy or distribute this
> email without the author's prior permission. //Datavail/Business -
> Limited External Distribution

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com