[ADMIN] Creating a Read Only profile in 8.4

I am new at the Postgres DBA - Admin stuff. So when asked to create a read only profile for our database in Postgres 8.4 I did the following: * create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN; * select 'grant select on ' ||

Re: [ADMIN] Creating a Read Only profile in 8.4

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:

Re: [ADMIN] Creating a Read Only profile in 8.4

Della-Croce, Gregory greg_della-cr...@wycliffe.org writes: I am new at the Postgres DBA ó Admin stuff. So when asked to create a read only profile for our database in Postgres 8.4 I did the following: · create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB

Re: [ADMIN] Creating a Read Only profile in 8.4

Della-Croce, Gregory greg_della-cr...@wycliffe.org writes: I am new at the Postgres DBA - Admin stuff. So when asked to create a read only profile for our database in Postgres 8.4 I did the following: * create role RO_User password 'xxx' NOSUPERUSER NOCREATEDB NOCREATEROLE