Re: Creating a Read Only profile in 8.4

From: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Creating a Read Only profile in 8.4
Date: 2012-06-08 12:55:01
Message-ID: b48721454ee46381e04a6e403f07a686@neslonek.homeunix.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 8 Jun 2012 08:29:30 -0400, Della-Croce, Gregory wrote:
> The commands worked fine. But when I connected as RO_User and did a
> select against a simple table in the DB, I got access denied on the
> table.

Check the permissions for that user on the schema public, too.

Jan

--
professional: http://www.oscar-consult.de
private: http://neslonek.homeunix.org/drupal/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2012-06-08 13:22:53 Re: Creating a Read Only profile in 8.4
Previous Message Della-Croce, Gregory 2012-06-08 12:29:30 Creating a Read Only profile in 8.4