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;
Permissions – How to GRANT SELECT to All Tables in PostgreSQL
permissionspostgresqlsqluser-management
Related Topic
- Postgresql – Proper Way to Grant Permissions in PostgreSQL
- PostgreSQL deleteing old records from log tables
- Postgresql – How to create a PostgreSQL web application user with limited privileges as easy as possible
- Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do
- Sql-server – With SQL Server (2008), can you grant create table permission within a schema
- Mysql – thesql grant select to ONE table on ALL database
- Postgresql – How to apply PostgreSQL “GRANT ALL ON ALL TABLES” to new tables
Best Answer
I thought it might be helpful to mention that, as of 9.0, postgres does have the syntax to grant privileges on all tables (as well as other objects) in a schema:
Here's the link.