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

Re: Creating a Read Only profile in 8.4

From: René Romero Benavides <ichbinrene(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Creating a Read Only profile in 8.4
Date: 2012-06-08 19:13:21
Message-ID: 4FD24ED1.10201@gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Am 08.06.2012 08:59, schrieb Tom Lane:
> "Della-Croce, Gregory"<Greg_Della-Croce(at)wycliffe(dot)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
>
You'll need to grant usage on the schema to your RO_User role as well.

GRANT USAGE ON SCHEMA public TO RO_User;

for each database you'll allow him to connect to.
-- 
pglearn.blogspot.mx:postgresql recipes <http://pglearn.blogspot.mx/>
*Twitter*.You might consider to follow *(at)sqlhotfix*

In response to

pgsql-admin by date

Next:From: René Romero BenavidesDate: 2012-06-08 19:30:32
Subject: Re: Question about PITR backup
Previous:From: Josh KupershmidtDate: 2012-06-08 19:06:23
Subject: Re: How To Change Password Hash Algorithm From MD5 to SHA-256

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