postgresqlrole

postgres role to access all schema


I am using postgres 9.4 database with many schemas. How can I create a login role that can select table of all table of all schema and also any new schema that we create in the database


Solution

  • To answer your comment I think this statement will work:

    ALTER DEFAULT PRIVILEGES 
    FOR ROLE role_name
    IN SCHEMA public
    GRANT ALL PRIVILEGES ON TABLES TO role_name;