We have migrated to new Google sites!
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)