do postgresql

Black Buffalo answered on February 4, 2022 Popularity 7/10 Helpfulness 5/10

answer do postgresql

do postgresql

Comment

DO $$DECLARE r record;
BEGIN
    FOR r IN SELECT table_schema, table_name FROM information_schema.tables
             WHERE table_type = 'VIEW' AND table_schema = 'public'
    LOOP
        EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
    END LOOP;
END$$;

Popularity 7/10 Helpfulness 5/10 Language sql

Source: www.postgresql.org

Tags: postgresql sql

Link to this answer
Share Copy Link

Contributed on Feb 04 2022

Black Buffalo

0 Answers Avg Quality 2/10

do postgresql

Contents

More Related Answers

do postgresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.