[ADMIN] Read Only Role

[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-tp5034628p5034628.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

[M. D.]

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

[CS DBA]

Post by M. D.

Post by 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.
--
http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

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

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

[ashok raj]

GRANT SELECT on all tables in schema public to user12 ;

Post by senthilnathan
Its a session variable. It can be reset(Read Write Mode) by the user itself
--
http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
http://www.postgresql.org/mailpref/pgsql-admin