pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRead Only Role
5+ messages / 4 participants
[nested] [flat]
* Read Only Role
@ 2011-11-30 05:52 senthilnathan <senthilnathan.t@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: senthilnathan @ 2011-11-30 05:52 UTC (permalink / raw)
To: pgsql-admin
Is there any simple way to define read only roles. Basically that user should
be able to login and be able to do *select* statements alone. It should be
applied for all tables in all schemas in a database.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read Only Role
@ 2011-12-01 00:05 M. D. <lists@turnkey.bz>
parent: senthilnathan <senthilnathan.t@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: M. D. @ 2011-12-01 00:05 UTC (permalink / raw)
To: senthilnathan <senthilnathan.t@gmail.com>; +Cc: pgsql-admin
On 11/29/2011 11:52 PM, senthilnathan wrote:
> Is there any simple way to define read only roles. Basically that user should
> be able to login and be able to do *select* statements alone. It should be
> applied for all tables in all schemas in a database.
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
Google is your friend:
http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read Only Role
@ 2011-12-02 01:19 CS DBA <cs_dba@consistentstate.com>
parent: M. D. <lists@turnkey.bz>
0 siblings, 1 reply; 5+ messages in thread
From: CS DBA @ 2011-12-02 01:19 UTC (permalink / raw)
To: M. D. <lists@turnkey.bz>; +Cc: senthilnathan <senthilnathan.t@gmail.com>; pgsql-admin
On 11/30/2011 05:05 PM, M. D. wrote:
>
> On 11/29/2011 11:52 PM, senthilnathan wrote:
>> Is there any simple way to define read only roles. Basically that
>> user should
>> be able to login and be able to do *select* statements alone. It
>> should be
>> applied for all tables in all schemas in a database.
>>
>> --
>> View this message in context:
>> http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html
>> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>>
> Google is your friend:
> http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql
>
>
>
I think you can do this:
ALTER USER [user] SET TRANSACTION READ ONLY;
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read Only Role
@ 2011-12-02 05:31 senthilnathan <senthilnathan.t@gmail.com>
parent: CS DBA <cs_dba@consistentstate.com>
0 siblings, 1 reply; 5+ messages in thread
From: senthilnathan @ 2011-12-02 05:31 UTC (permalink / raw)
To: pgsql-admin
Its a session variable. It can be reset(Read Write Mode) by the user itself
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Read Only Role
@ 2011-12-04 01:18 ashok raj <ashokexplorer@gmail.com>
parent: senthilnathan <senthilnathan.t@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: ashok raj @ 2011-12-04 01:18 UTC (permalink / raw)
To: senthilnathan <senthilnathan.t@gmail.com>; +Cc: pgsql-admin
GRANT SELECT on all tables in schema public to user12 ;
On Fri, Dec 2, 2011 at 11:01 AM, senthilnathan <senthilnathan.t@gmail.com>wrote:
> Its a session variable. It can be reset(Read Write Mode) by the user itself
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Regards,
Ashokraj
9940419867
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-12-04 01:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-11-30 05:52 Read Only Role senthilnathan <senthilnathan.t@gmail.com>
2011-12-01 00:05 ` M. D. <lists@turnkey.bz>
2011-12-02 01:19 ` CS DBA <cs_dba@consistentstate.com>
2011-12-02 05:31 ` senthilnathan <senthilnathan.t@gmail.com>
2011-12-04 01:18 ` ashok raj <ashokexplorer@gmail.com>
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