From: Tom Lane <tgl@sss.pgh.pa.us>
To: Della-Croce, Gregory <Greg_Della-Croce@wycliffe.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Creating a Read Only profile in 8.4
Date: Fri, 08 Jun 2012 09:59:14 -0400
Message-ID: <11689.1339163954@sss.pgh.pa.us> (raw)
In-Reply-To: <F1CFB1E7A51CD846898BB039F441E04F095A53C641@elijah>
References: <F1CFB1E7A51CD846898BB039F441E04F095A53C641@elijah>
"Della-Croce, Gregory" <Greg_Della-Croce@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 'xxxxxxxxxxx' NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;
> * select 'grant select on ' || tablename || ' to \"RO_User\"; 'from pg_tables where schemaname = 'public';
Uh, that only printed the GRANT commands you needed, it didn't execute
them.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Greg_Della-Croce@wycliffe.org
Subject: Re: Creating a Read Only profile in 8.4
In-Reply-To: <11689.1339163954@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox