Do postgresql

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$$;

Source: postgresql.org

Similar codes

2 votes141 views1 answer
Sql ignore accents
SQL
0 vote145 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote140 views1 answer
Db format in quotation
SQL
52 votes317 views6 answers
Rename column sql
SQL
14 votes144 views1 answer
Sql value of string
SQL
3 votes145 views1 answer
Locate sql server
SQL
1 vote103 views1 answer
Into sql
SQL
4 votes174 views6 answers
Select sql
SQL
0 vote133 views3 answers
Postgresql grant alter table to user
SQL
18 votes104 views2 answers
How to get all the tables displayed in oracle
SQL