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
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
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
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
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