Generate Scripts to grant DML priv to other user or role

Post date: May 02, 2013 1:31:55 AM

sachi=> select 'grant select,insert,update, delete on '||schemaname||'.'||tablename||' to gpadmin' from pg_tables where tableowner='sachi';

                                   ?column?                                  

------------------------------------------------------------------------------

 grant select,insert,update, delete on sachi.countries to gpadmin

 grant select,insert,update, delete on sachi.departments to gpadmin

 grant select,insert,update, delete on sachi.employees to gpadmin

 grant select,insert,update, delete on sachi.job_history to gpadmin

 grant select,insert,update, delete on sachi.jobs to gpadmin

 grant select,insert,update, delete on sachi.locations to gpadmin

 grant select,insert,update, delete on sachi.regions to gpadmin

 grant select,insert,update, delete on sachi.ext_countries_error to gpadmin

 grant select,insert,update, delete on sachi.ext_countries to gpadmin

 grant select,insert,update, delete on sachi.ext_departments_error to gpadmin

 grant select,insert,update, delete on sachi.ext_departments to gpadmin

 grant select,insert,update, delete on sachi.ext_employees_error to gpadmin

 grant select,insert,update, delete on sachi.ext_employees to gpadmin

 grant select,insert,update, delete on sachi.ext_job_history_error to gpadmin

 grant select,insert,update, delete on sachi.ext_job_history to gpadmin

 grant select,insert,update, delete on sachi.ext_jobs_error to gpadmin

 grant select,insert,update, delete on sachi.ext_jobs to gpadmin

 grant select,insert,update, delete on sachi.ext_locations_error to gpadmin

 grant select,insert,update, delete on sachi.ext_locations to gpadmin

 grant select,insert,update, delete on sachi.ext_regions_error to gpadmin

 grant select,insert,update, delete on sachi.ext_regions to gpadmin

(21 rows)