Postgres Pro
Downloads
Home   >   mailing lists

Re: priviliges issues - Mailing list pgsql-admin

From David G. Johnston
Subject Re: priviliges issues
Date
Msg-id CAKFQuwZcNjdo2KpmYO=2B4Dvbe0c5FbkqHoEkZJnRkAwmqMcrw@mail.gmail.com
Whole thread Raw
In response to priviliges issues  (Ankush Chawla <ankushchawla03@gmail.com>)
List pgsql-admin
Tree view
You should write new emails and not reply to unrelated ones with individuals already copied and without removing the bogus quoted email.

On Wed, Apr 15, 2020 at 11:05 AM Ankush Chawla <ankushchawla03@gmail.com> wrote:

ERROR:  permission denied for schema s1
LINE 1: select * from s1.new;

This error seems mostly self-explanatory - the user "user2" doesn't have permission to use schema "s1".  See the documentation for how to grant this permission - its similar to how you granted select on the table.

David J.


pgsql-admin by date:

Previous
From: Mohammed Afsar
Date:
Subject: Re: priviliges issues
Next
From: "David G. Johnston"
Date:
Subject: Re: priviliges issues