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

Re: select only user

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: select only user
Date: 2008-01-18 13:54:46
Message-ID: fmqb36$ole$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-admin
Jessica Richard написа:
> Thanks!!!
> "ALTER USER username SET default_transaction_read_only to true" worked. 
> 
> One more question:
> 
> where do I see the current setting of "default_transacton_read_only (true for false) for each user on the system? Is there a table that keeps this kind of info for all users?
[...]


SELECT * FROM pg_roles where rolname = '<username>';


-[ RECORD 1 ]-+-------------------------------------
rolname       | <username>
rolsuper      | f
rolinherit    | t
rolcreaterole | f
rolcreatedb   | f
rolcatupdate  | f
rolcanlogin   | t
rolconnlimit  | -1
rolpassword   | ********
rolvaliduntil |
rolconfig     | {default_transaction_read_only=true}
oid           | 53531114


(http://www.postgresql.org/docs/current/static/database-roles.html)



-- 
Milen A. Radev


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2008-01-18 15:42:04
Subject: Re: Cannot bind socket
Previous:From: Jessica RichardDate: 2008-01-18 13:46:33
Subject: Re: select only user

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