Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group