Re: [ADMIN] Read Only Role

2011-12-03 Thread ashok raj
GRANT SELECT on all tables in schema public to user12 ; On Fri, Dec 2, 2011 at 11:01 AM, senthilnathan 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-tp5034628p504

Re: [ADMIN] Read Only Role

2011-12-02 Thread senthilnathan
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 (p

Re: [ADMIN] Read Only Role

2011-12-01 Thread CS DBA
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. -- V

Re: [ADMIN] Read Only Role

2011-11-30 Thread M. D.
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://pos

[ADMIN] Read Only Role

2011-11-30 Thread senthilnathan
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-tp5