GRANT SELECT to all tables in postgresql

Posted by Adam Matan on Server Fault See other posts from Server Fault or by Adam Matan
Published on 2009-08-30T14:11:05Z Indexed on 2010/04/05 18:13 UTC
Read the original article Hit count: 463

Hi,

Is there a one-liner that grants the SELECT permissions to a new user postgresql?

Something that would implement the following pseudo-code:

GRANT SELECT ON TABLE * TO my_new_user;

© Server Fault or respective owner

Related posts about postgresql

Related posts about user-management