SELECT ‘grant select,update on ‘ || sequence_name || ‘ to r_pmsdata_qry;’ AS tmm1 FROM information_schema.sequences UNION ALL SELECT ‘grant select on ‘ || tablename || ‘ to r_pmsdata_qry;’ AS tmm FROM pg_tables T WHERE T .tableowner = ‘pmsdata’ UNION ALL SELECT ‘grant select,insert,update,delete,truncate on ‘ || tablename || ‘ to r_pmsdata_dml;’ AS tmm FROM pg_tables T WHERE T .tableowner = ‘pmsdata’;
