proc sql;
   connect to oracle as tempdb
           (user=student pw=sesame path=temppath
            connection=global);
   select *
      from connection to tempdb
              (select ssn, lname, fname, activity
                  from members 
                  where contacts<5);
   execute (grant update on members
            to student) by tempdb;
   
quit;