Grant Select on all Tables Owned By Specific User DB Scripts 1 September 20201 September 2020 Administrator BEGIN FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner='TheOwner') LOOP EXECUTE IMMEDIATE 'grant select on '||R.owner||'.'||R.table_name||' to TheUser'; END LOOP; END; Share this post: on Twitter on Facebook on Google+ Post Views: 589